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 Björnsson

      Hi,

      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

       

      Sum({$<SaleDate={'2015-03-01'},RegDate={'<=2015-03-26'}>}SalesAmount)

       

      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.

       

      Regards

      Birkir