Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
SK28
Creator
Creator

One ListBox should impact on Particular Graph in Qlikview Sheet

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.

1 Solution

Accepted Solutions
effinty2112
Master
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

View solution in original post

4 Replies
vishsaggi
Champion III
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))

effinty2112
Master
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

SK28
Creator
Creator
Author

Thank you... It's working

effinty2112
Master
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