Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Help with Alternate state in chart expression

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

J

1 Solution

Accepted Solutions

Re: Help with Alternate state in chart expression

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)


Capture.PNG

View solution in original post

3 Replies

Re: Help with Alternate state in chart expression

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)


Capture.PNG

View solution in original post

MVP
MVP

Re: Help with Alternate state in chart expression

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

2017-05-12 17_24_11-QlikView x64 - [E__Users_Stefan_Downloads_tEST (70)_2.qvw].png

AND-Mode

Not applicable

Re: Help with Alternate state in chart expression

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.