Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

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
sunny_talwar

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

swuehl
MVP
MVP

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
Author

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.