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.

       

      Thanks,

      David