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.
Try like below:
1. Create an inline load to create the filter
2. Assuming your measure as 'Amt', create a table with the following in the expression:
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
Without any selection: