5 Replies Latest reply: Mar 28, 2015 4:09 PM by Piet Hein van der Stigchel RSS

    Qlik Sense set analysis with date variable less than or equal to

    Birkir Bjornsson


      I have a set analysis calculates for a given period, it works fine when dates are hard coded but when I try to use variables I mess things up. I have tried many different things and read many threads here but I simply cannot not solve this. This is the set analysis




      The variables look like this

      LET v_YesterDay = Date(Today()-1,'YYYY-MM-DD');

      LET v_MonthStart = monthstart(Today());


      So I am trying to use the variables in the set analysis instead of the hard coded dates. I just cant understand why I cant make it work.

      All hints are greatly appreciated.