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: 
ilanbaruch
Specialist
Specialist

Alternate state with set analysis

hi all,

in my model i have table with an expression :

Sum({$<StatusFlag={'1'}>}Quantuty)

i want to add to this expression the alternate states crated 2  : GroupA, GroupB

the dimensions that will be assigned to these states are : Year, Month, Quarter

is it possible to use both states (in different expression ) within same object (table) ?

 

advanced thanks

 

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Set expression syntax with state is like:

Sum({State1<Filter={'FilterValue'}>} Measure)

If this doesn't help, try to share a sample app.

View solution in original post

4 Replies
tresesco
MVP
MVP

Yes, possible. Technically you can use two expressions in one chart with different alternate states. But the bigger question is :  wouldn't this confuse the users ?

ilanbaruch
Specialist
Specialist
Author

Hi Tresesco, thank you for your replay,

we want to achieve period analysis,

first expression would be used with state1 and will respond to state1 filter pane 

and second expression would be used with state2 and will respond to state2 filter pane 

the third expression would be the delta/trend between two states - users are already familiar with it from QV..

what would be the syntax to this expression in order to respond to State1/State2 ?

 

 

 

tresesco
MVP
MVP

Set expression syntax with state is like:

Sum({State1<Filter={'FilterValue'}>} Measure)

If this doesn't help, try to share a sample app.

ilanbaruch
Specialist
Specialist
Author

many thanks tresesco