Skip to main content
The way to achieve your own success is the willingness to help somebody else. Go for it!
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor III
Partner - Contributor III

Solution for filtering data by using AND + OR at the same time in Qlik Sense 3.2

For a long time we where looking for a fast solution to filter data.

We needed something like:

Filter1 + [Option1a]+[Option1b]     OR  Filter2 + [Option2a]+[Option2b]  OR  Filter3 + [Option3a]+[Option3b]   …….

Filter-n is always mandatory.

Option-na  and Option-nb is optional.

So we use AND + OR at the same time.

The Qlik support told us it would not be possible without extensions.

A solution via IF is working but the integration of 3 columns is very slow.

So we are now using “set analysis”.

The solution has 4 columns with 3 filters per column. With 2.3 million dataset-rows the result appears within a second.

There is a trick to split the OR from the AND.

The OR’s are integrated in the frontend. The AND’s are realized in 8 variables.

The column is:

=Count({$(VARTAB1)  + $(VARTAB2)   +   $(VARTAB3) +   $(VARTAB4)  } Customer)

One variable looks like


< Car1={'$(=getfieldselections(CarFilter1))'}  , Color1={$(=if(getselectedcount(ColorFilter1)>0,getfieldselections(ColorFilter1),'*'))}  , Year1={$(=if(getselectedcount(YearFilter1)>0,getfieldselections(YearFilter1),'*'))}          >

For better understanding look the example app and use the bookmark or your own selections.

Have a lot of fun

PS: be careful       “/” is not allowed in the colors or years


0 Replies