Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Use Alternate States as identifier. Identifier should be place between left curly bracket and left angle bracket
=Sum({state1<Date={'$(=MAX(Date))'}>}Sales)
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)