2 Replies Latest reply: Feb 26, 2018 11:06 PM by bhavani b RSS

    Alt()

    bhavani b

      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.

        • Re: Alt()
          Shilpan Patel

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

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

            • Re: Alt()
              bhavani b

              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)