topic Re: Chart affected by multiple alternate states in QlikView

Chart affected by multiple alternate states

Thu, 14 May 2015 15:39:20 GMT

Hi,

I want to add a filter onto my document where the selections only affect the data in that one chart, and no others, but still have all the other filters effect it and others as normal. Is it possible to do this using alternate states?

So for example,

In my document i have two charts (chart 1, chart 2) and two list boxes (lb1, lb2). For chart 1 i want it to only be affected by selections in lb1, but chart 2 should change with selections in both lb1 and lb2

Re: Chart affected by multiple alternate states

sunny_talwar — Thu, 14 May 2015 15:42:24 GMT

You can do this before alternate state as well:

Chart 1's expression will have this as a set analysis:

{<lb2field = >} and this will force the expression to now change when you make a selection in lb2 list box.

HTH

Best,

Sunny

Re: Chart affected by multiple alternate states

Gysbert_Wassenaar — Thu, 14 May 2015 15:48:27 GMT

You can use set analysis expressions for this. You'll have to decide how the alternate states should interact.

Sum( {AltState1 + AltState2} Value)

Sum( {AltState1 - AltState2} Value)

Sum( {AltState1 * AltState2} Value)

Sum( {AltState1 / AltState2} Value)

+ Union: Returns the set of all records that belong to the unioned sets

- Exclusion: Returns records that belong to the first but not the other of the two set identifiers.

* Intersection: Returns records that belong to both of the set identifiers.

/ Symmetric Difference: Returns a set that belongs to either, but not both of the set identifiers.

Re: Chart affected by multiple alternate states

Clever_Anjos — Thu, 14 May 2015 16:13:31 GMT

Please find attached a sample