business-intelligencedashboardqlikviewdashboard-designerqliksense

How to select a particular number in a list box and make the other list box to only display the numbers greater than the selected number in QlikView?


I have two list boxes: Box1 and Box2. Box1 has values 10,20,30,40 etc and Box2 has the same 10,20,30 etc.

After creating two separate list boxes for Box1 and Box2 respectively in the dashboard, how do I get to show only the values in Box2 which are greater than the selected value/values in Box1.

Example: When I click 20 in Box1, I want the values 30, 40 etc to be displayed or shown in box2 i.e., the values greater than 20 has to be displayed. Thank you.


Solution

  • An alternative way to do this would be to create a List Box but instead of setting it to use a normal field, set it to use an expression instead (select it in the "Field" drop down in the properties).

    You could then use the following expression which should do the trick:

    =aggr(if(F2 > max(F1),F2,if(GetSelectedCount(F1)<>0,null(),F2)),F2)
    

    In the above, the first field is F1 (i.e. Box1) and the second is F2 (i.e. Box2).

    An example of how it looks in practice is shown below (the third box on the right contains the expression), the first image shows what happens if some values are selected in F1 - the list of values are filtered.

    In the second image, a selection has been made in this new list box, and as you can see, it makes a selection against F2 automatically.

    An example from QlikView when using the expression An example from QlikView when using the expression and selecting values