5 Replies Latest reply: Mar 28, 2018 7:19 AM by Xavier Garcia RSS

    Variables in set analysis

    carlos diago

      Hi all,

       

       

      I´m making a new dashboard in Qlik.

       

      My bussiness are related with incidences, so, count(NumberIncidences) will be usual to use...

       

      Anyway, I´m trying to use variables in a simple set analysis.

       

      Here my var:

       

      nameVar: vCurrentMonth

      expression of var: vCurrentMonth = Month(Today())

       

      Y would like to know my incidences in a current month with set analysis, i would like to know this month, next month, etc.

      I would like to have this information instanly, without filters applied. So:

       

      Here my set analysis expression:

       

      =count({<MONTH={'=$(vCurrentMonth)"}>}NumberIncidences)

       

       

      I´m totally deseperate, because I tested to get and represent the value of my variable typing the next:

       

      =$(vcurrentMonth)

       

      and the result is 3. that´s perfect!, but when i try to put in a setAnalysis Expression...EXPLOIT! never work!

       

      any help or manual or whatever will be very very helpful!

       

      Thanks in advance