Discussion board where members can get started with Qlik Sense.
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.
Just use dollar sign expansion to replace the hard coded values with the variable content:
View solution in original post
Maybe have a look at this series of blog posts about using set analysis and point in time reporting
The Magic of Set Analysis - Point In Time Reporting • Blog • AfterSync
Please See attached.
It might help you.
That is what I tried and it worked. The problem is that hardcodes Q1 and Q2 into the formula. I want to pass a variable so when the Q2 changes to Q3 I dont have to update the formula.
Does this make sense?