What is the synthax for IN condition ?

Question

Hello, I have a widget table, and in would like to keep only two lines, one for cd_domain = disease  and one for cd domain = treatment

to do that, i use the IN filters, but i can't find the synthax to filter on two (Or more) differents value.

In FILTERS in the widget configuration i am doing

Dataset X cd_domain IN  (disease, treatment)

Dataset X cd_domain IN  ('disease', 'treatment')

Dataset X cd_domain IN  disease, treatment  

I try multiple differents synthax but it is still not working. Do you know what is the right synthax to filter on multiple value with IN condition?  

Do you have any solution ? Thanks :)

Answer 1

Dear tleparmentier,

the third one you wrote is the right sintax. For example, using QUARTER column of SALES dataset you should use

Q1,Q2 --> NOT Q1, Q2

Just remember to

- DON'T use spaces between values

- remember to click on filter save icon BEFORE saving widget config, in order to add the filter, you should see it into the list on FILTERS tab.

Regards

Matteo