4 Replies Latest reply: May 21, 2016 1:51 PM by Stefan Wühl RSS

    Using Variables in Chart Expressions or Measures

    David Young

      Hi All.


      I am quite new to Qlik Sense and trying to calculate Sales from Last Quarter vs This Quarter


      So I have a Purchase Amount and a Purchase Date.


      I set the following in the load Statement


      LET vThisQuarter = 'Q' & Ceil(Month(Today())/3);

      LET vLastQuarter = 'Q' & Ceil(Month(Today())/3-1);


      Now I am trying to create the formula that will give me Q1 and Q2 sales.  I am not sure what to do.  Any suggestions.