Filter above a threshold/below threshold/or all values
Hi,
I am working on some data and one of the requirements is that the user sets a threshold value. We will say I am working with sales data. This threshold indicates the difference between small sales/large sales. Filtering data based on this value alone is simple... where it gets tricky is this:
They want also to have a dropdown to filter all the charts (Show only small large sales/Show only small sales/Show all sales). How can I do this easily? I was thinking some big nasty if statement based on a variable I set to generate the set that I need?
If you can compromise slightly on the display, create a list box with this expression:
if(Sale>$(Threshold),'Large Sales','Small Sales')
It then uses normal QlikView functionality and normal QlikView GUI concepts. If neither or both are selected, all sales display. If one or the other is selected, only that kind of sale is displayed. I wouldn't want to create the dropdown with three values, since that's contrary to normal QlikView GUI concepts (you don't have a specific value that means "all values", you actually select all values, or select nothing).
