Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
was wondering if anyone would be able to help me,
Thanks in Advance.
I Have 3 Charts and 3 List boxes.
the Requirement is that 1 List box (in attached Image file, list box 3) should not impact Graph - 3
but should work for other Graphs in the Sheet.
In the attached example
LIST BOX 1 Should have impact on GRAPH 1,2,3
LIST BOX 2 Should have impact on GRAPH 1,2,3
LIST BOX 3 Should have impact on GRAPH 1,2 but not on graph -3
Please find the Attached, and let me know if you have any queries.
Thanks.
Hi Krishna,
Let's say that your Listbox3 is of a dimension Dim3. You can make the expression in Graph 3 disregard selections in Dim3. Say the Graph 3 expression is sum(Amount).Change that to
sum({$<Dim3 = >}Amount)
The little piece of set analysis tells QlikView to disregard selections made in Dim3 when calculating sum(Amount).
Hope this helps
Andrew
In your Graph 3 for your expressions write like below: I don't know what expressions you have so just replace this condition with those valid expression.
= IF(GetSelectedCount(Listbox3) > 0, Sum({1}Value), Sum(Value))
Hi Krishna,
Let's say that your Listbox3 is of a dimension Dim3. You can make the expression in Graph 3 disregard selections in Dim3. Say the Graph 3 expression is sum(Amount).Change that to
sum({$<Dim3 = >}Amount)
The little piece of set analysis tells QlikView to disregard selections made in Dim3 when calculating sum(Amount).
Hope this helps
Andrew
Thank you... It's working
Hi Krishna,
Very glad to help. Please don't forget to close the thread by marking my answer as correct if my solution is working for you.
Kind regards
Andrew