topic Re: One ListBox should impact on Particular Graph in Qlikview Sheet in QlikView

One ListBox should impact on Particular Graph in Qlikview Sheet

SK28 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: One ListBox should impact on Particular Graph in Qlikview Sheet

vishsaggi — Sat, 29 Jul 2017 15:43:58 GMT

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

Re: One ListBox should impact on Particular Graph in Qlikview Sheet

effinty2112 — Sat, 29 Jul 2017 17:12:40 GMT

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

Re: One ListBox should impact on Particular Graph in Qlikview Sheet

SK28 — Mon, 31 Jul 2017 11:50:47 GMT

Thank you... It's working

Re: One ListBox should impact on Particular Graph in Qlikview Sheet

effinty2112 — Mon, 31 Jul 2017 12:13:21 GMT

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