Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Multiple Search in Qlik Sense Desktop

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

3 Replies
reddys310
Honored Contributor II

Re: Multiple Search in Qlik Sense Desktop

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:

Capture.PNG

Thanks,

Sangram.

Re: Multiple Search in Qlik Sense Desktop

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)

Not applicable

Re: Multiple Search in Qlik Sense Desktop

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