Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Set expression syntax with state is like:
Sum({State1<Filter={'FilterValue'}>} Measure)
If this doesn't help, try to share a sample app.
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 ?
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 ?
Set expression syntax with state is like:
Sum({State1<Filter={'FilterValue'}>} Measure)
If this doesn't help, try to share a sample app.
many thanks tresesco