Alt()

[bhavvibudagam]

Hi Experts,

I have tried this Alternate states extension with the same example mentioned in the video with expressions

Sum(Sales) and Sum({Alt}Sales) its working fine.

Comparative Analysis - Alternate States with Qlik Sense

In my application I have Two set analysis expressions like below in Two charts. Please let me know where to apply {Alt} here to work with this extension.

1. =Sum({<Date={'$(=MAX(Date))'}>}Sales)

2. =Sum({<Date={'$(=MAX(Date))'}>}Interval(EndTime-starttime,'hh:mm'))

Thanks in advance.

[shilpan]

Use Alternate States as identifier. Identifier should be place between left curly bracket and left angle bracket

=Sum({state1<Date={'$(=MAX(Date))'}>}Sales)

[bhavvibudagam]

Hi,

Thanks for your reply.

I have set the state in between left curly bracket and left angle bracket but its not giving the result correctly at alternate state dimension.

I have passed the state like this then its working.

=Sum({<Date={'$(=MAX(Date))'}>}{AltState}Jobs)