Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
piyush_s11
Creator
Creator

Qlik Sense Filter Criteria

I need a filter in Qlik Sense to be applied where filter would have 3 values 1 Million, 2 Million, 3 Million.

Now if user selects 1 Million then a table should filter the values above 1 Million & below 2 Million

if user selects 2 Million then table should filter the values above 2 Million & below 3 Million

if user selects 3 Million then it should show values above 3 million.

Please Note : Filter values i.e 1 Million, 2 Million, 3 Million are not present in the database from which I am facing the data.

How to apply the filter ? Please find below snapshot of the table.

clipboard_image_0.png

Thanks

Labels (2)
1 Reply
_armoco_
Partner - Creator II
Partner - Creator II

Hi Piyush,

Try like below:

1. Create an inline load to create the filter

clipboard_image_0.png

2. Assuming your measure as 'Amt', create a table with the following in the expression:

if(len(GetCurrentSelections(Filter))=0, Amt,

Pick(WildMatch(Filter,'1M', '2M', '3M'),
if(Amt>10 and Amt<=20, Amt,Null()),
if(Amt>20 and Amt<=30, Amt,Null()),
if(Amt>30, Amt,Null())

))  //Change the upper limit and ;lower limit as required

3. Pull the created inline field as filter and in data handling uncheck 0 values option if necessary

 

Output:

Without any selection:

clipboard_image_2.png

With selections:

clipboard_image_3.png

 

clipboard_image_4.png

clipboard_image_5.png

 

Regards,

Arjun