topic Help with Alternate state in chart expression in QlikView

Help with Alternate state in chart expression

Wed, 25 Nov 2020 16:16:04 GMT

Hi people,

Could you guys help me with the following problem

I have created 2 alternate states, and i want to get:

when state A = AA , State B = BB,

we will look for Last name(regardless of what the first name is ) :

i.e. Last Name A has both AA and BB, so sum all amounts for the Last name A

Last Name B doesn't have both AA and BB, so we ignore it.

Again, we would ignore Last Name C.

Thanks

Re: Help with Alternate state in chart expression

sunny_talwar — Fri, 12 May 2017 15:18:49 GMT

B does seem to have both AA and BB... If you agree, try this

=Sum({<[Last Name] = P({<State = [StateA]::State>})*P({<State = [StateB]::State>})>}Amount)

Re: Help with Alternate state in chart expression

swuehl — Fri, 12 May 2017 15:25:51 GMT

Or use an AND mode list box instead of the alternate states, this allows also to select more combinations of values, also using NOT.

AND-Mode

Re: Help with Alternate state in chart expression

Mon, 15 May 2017 15:30:13 GMT

Thanks Stefan for the suggestion, however the requirement is to use a different list box... so i will have to stick with the alternate state. but thanks for the suggestion, I will use it next time.