Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for
Did you mean:
Creator

## One ListBox should impact on Particular Graph in Qlikview Sheet

Hi,

was wondering if anyone would be able to help me,

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.

1 Solution

Accepted Solutions
Master

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

4 Replies
Champion III

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))

Master

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

Creator
Author

Thank you... It's working

Master

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

Community Browser