3 Replies Latest reply: Dec 12, 2016 2:19 AM by AC BC RSS

    How do I make a variable value constant, irrespective of chart selection

    KANCHANA DORAISWAMY

      Hi all,

       

      I have a calculated variable in my Qliksense Desktop (3.1) app that I wish to retain a constant. But right now, the value of this variable, which I have displayed in a KPI object, keeps changing based on my chart selections.

       

      As an example, one of the variables is calculated as below :

       

      vCount = (Count(if([Date] = MaxDate and ([Clinical Execution Time (latest)]-[Clinical Execution Time (prev)])>0, [Dataset Name])))

       

      Please help.

       

      Thanks,

      Kanchana