8 Replies Latest reply: Oct 27, 2016 5:48 AM by ALEJANDRO Perez Martin RSS

    Time variable in setAnalysis (Qlik Sense)

    ALEJANDRO Perez Martin

      Hi all,

       

      I got the following situation:

       

      I'm trying to set a time variable in the set analysis. To do so this is what I've done so far:

       

      1. Created a variable named: vB. This is: =AddYears(Max([FirstRegisterDate.autoCalendar.Year]), -1)

      2. This variable returns a numeric value: 42005 (in the automatic formatting)

      3. Then in the kpi's set analysis I typed:

                    Count({$<[FirstRegisterDate.autoCalendar.Year]] ={'$(=vB)'}>} [uniquecustomerid.CustomerBrand])



      And this doesn't work.

       

      Thanks for the help!