Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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
Highlighted
MVP
MVP

Re: Alternate state with set analysis

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
Highlighted
MVP
MVP

Re: Alternate state with set analysis

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 ?

Highlighted
Creator III
Creator III

Re: Alternate state with set analysis

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 ?

 

 

 

Highlighted
MVP
MVP

Re: Alternate state with set analysis

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

Highlighted
Creator III
Creator III

Re: Alternate state with set analysis

many thanks tresesco