topic Alternate state with set analysis in QlikView

Alternate state with set analysis

ilanbaruch — Mon, 08 Apr 2019 06:22:55 GMT

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

Re: Alternate state with set analysis

tresB — Mon, 08 Apr 2019 06:32:05 GMT

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 ?

Re: Alternate state with set analysis

ilanbaruch — Mon, 08 Apr 2019 06:47:50 GMT

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 ?

Re: Alternate state with set analysis

tresB — Mon, 08 Apr 2019 07:01:23 GMT

Set expression syntax with state is like:

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

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

Re: Alternate state with set analysis

ilanbaruch — Mon, 08 Apr 2019 10:28:21 GMT

many thanks tresesco