# New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
New Contributor III

## 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.

Tags (4)
1 Solution

Accepted Solutions
Honored Contributor

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

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
Esteemed Contributor III

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

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

Honored Contributor

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

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

New Contributor III

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

Thank you... It's working

Honored Contributor

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

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