Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

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

Highlighted
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

Highlighted
Contributor III
Contributor III

Thank you... It's working

Highlighted
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