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

    Time variable in setAnalysis (Qlik Sense)

      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!