Discussion board where members can get started with Qlik Sense.
Please see attached. I need to create two expressions with reference to the latest date:
1. Sum of Sales for the current fortnight; and
2. Sum of Sales for the previous fortnight
The fortnight figures should change automatically with reference to the latest date. Any ideas how I can achieve the result?
Try the following:
Sales for last 14 days:
Sales for previous 14 days:
I don't think the above works . I need the figures for the fortnight periods as in the list box.
Your formula gives me the sales for the last 14 days based on the latest date.