Multiple Search in Qlik Sense Desktop

[#1]

I would like to know what is the best way to get search results for multiple items (compound search)

for example, I want all patients (HCNUMBER) who are taking Med A, Med C, and Med B together in the (MEDICATION) field

When I select all three items, it gives me all the patients bu who are taking them alone or together

[reddy-s]

Hi Mohamad,

Use the serach option on the top left corner of the screen. Its very handy and scans for relavent information in the entire data model

Check this:

Thanks,

Sangram.

[Gysbert_Wassenaar]

I don't think AND-mode is implemented yet in Qlik Sense.

You could try a table with HCNUMBER as dimension and an expression like count({<HCNUMBER={"=count({<MEDICATION={'Med A','Med C','Med B'}>}DISTINCT MEDICATION)=3"} DISTINCT HCNUMBER)

[#4]

Hi Mohamed,

This is And-Mode. It can be implemented in QlikView, but I have never tried it out in QlikSense.

There is a documentation on this though which may help you.

AND mode in Qlik Sense

Regards,

Rohan