topic Re: How can I make certain list boxes not affect certain graphs? in QlikView

How can I make certain list boxes not affect certain graphs?

Tue, 15 Jul 2014 19:01:01 GMT

I have multiple graphs and a bunch of list boxes that are all linked. I am trying to figure out how to have some of the graphs affected by all the list boxes, and other graphs to only be affected by some of the list boxes:

Example:

Graph A

Graph B

List Box X

List Box Y

List Box Z

Graph A affected by X, Y, and Z

Graph B affected only by X and Y

I have experimented with alternate states a bit, but could not quite work out how to get to the solution I desire. Thanks in advance for any help you can offer!

Re: How can I make certain list boxes not affect certain graphs?

jerem1234 — Tue, 15 Jul 2014 19:03:40 GMT

Use set analysis to ignore that field for the list box like:

Graph A:

sum(Sales}

Graph B:

sum({<Z=>}Sales)

Hope this helps!

Re: How can I make certain list boxes not affect certain graphs?

jaimeaguilar — Tue, 15 Jul 2014 19:05:57 GMT

Hi,

check alternate states, I think is what you're looking for

regards

Re: How can I make certain list boxes not affect certain graphs?

Wed, 16 Jul 2014 10:28:46 GMT

Hi Eric,

I would suggest you to check chart's expressions part of the set analysis. Just ignore the selection made in that specific listbox. Hope this helps.

Further, for more detail knowledge I would suggest you to view this infomrative video:- https://www.youtube.com/watch?v=8olMt2AOUJ8