topic Re: Range filter in App Development

Range filter

Wayne_101 — Sat, 16 Nov 2024 19:37:57 GMT

isn't there any other way to just give simple range filters where user has option of > and < operator or can have between clause, in simple words just a ranged filter.

This functionality is so much easier in tableau and power hence in qlik sense i haven't came across one fully functional solution.

my solution :

made 2 Variable :

vMax =max(sales)

vMin=max(sales)

then use above variables in sales measure like this :

= if((sum(Sales) >= $(vMin) AND sum(Sales) <= $(vMax)),sum(TotalCalls))

which gives me following output in screenshot no 5 filtering the data but leaving blank in sales column where condition not met:

please help

Re: Range filter

sunny_talwar — Wed, 20 Nov 2019 13:22:37 GMT

You can suppress those rows by going into the following properties: Add-ons -> Data handling -> Uncheck 'Include zero values'.

For the total, you can just change your expression to

Sum(Aggr( If((Sum(Sales) >= $(vMin) and Sum(Sales) <= $(vMax)), Sum(TotalCalls)) , YourDimensionsFromTheChart))

Re: Range filter

Wayne_101 — Thu, 28 Nov 2019 07:22:24 GMT

my dimension has millions of distinct values which is actually customer no , can you guide in this matter secondly how can i apply the selection made from my range filter to other sheets.

note : i have made multiple range filters.

Re: Range filter

sunny_talwar — Fri, 29 Nov 2019 15:54:23 GMT

I am not sure I understand the issue? "my dimension has millions of distinct values which is actually customer no" What does that have to do with the solution provided.

For the second condition... what exactly are you trying to do. Again, I am not really sure about the selections you are looking to have dashboard wide?

Re: Range filter

Wayne_101 — Tue, 03 Dec 2019 21:28:47 GMT

hi,

below is what i'm trying to do, creating normal filters and range filters for columns having alot of distinct values .

Requirement : using multiple filters lock the customers on certain criteria eg :

customer having sales > 5000 and qnty < 50 and profit between 200 and 1000

then show count(Distinct customers) with other dimensions.

after this sheet will be individual customer level sheet showing each customer who fulfilled above eg. criteria with some other kpis.

Issues :

1)filters should be applied per customer

2)totals should also change

3)dependencies between normal filter and range filters and with themselves too.

4) selection done in ranged filters don't get refreshed plus they don't show up in top selected tab too which makes it difficult to under which filter is applied which is not.

logic used in columns :

created two variables min and max then applied below expression in table columns :

= if((sum(Tax) >= $(vMinTax) AND sum(Tax) <= $(vMaxTax)),
if(isnull(sum(Tax)),null(),sum(Tax))
,null()
)

Re: Range filter

user42_qlik — Thu, 13 Jan 2022 12:37:52 GMT

Hi, I have multiple sheets with different KPIs and tables, how can I make the range filter selection apply to all of them? Do I need to specify such an expression for every single chart and custom objects I have used?