Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
Very new to QlikSense and would like some help!
I would like to display the sum of ARR (Annual recurring revenue) for the latest week only regardless of 'Week' filter.
Dimensions:
Week
Measures:
ARR
Thanks,
Jacob
Hi Jacob,
Create a master calendar first Creating A Master Calendar
use this in your code to create a flag for last week dates in your master calendar : InWeek([Date field], today(), -1) * (-1) AS [Last Week]
now make use of this flag in your set analysis : sum({$< [Last Week] = {1}>}[Annual recurring revenue])
this will always give you last weeks "Annual recurring revenue".
Thanks,
Sangram.
Hi Sangram,
Appreciate the prompt response.
Is there around this without having to use a 'Master Calendar'?
Thanks,
Jacob
Hi Jacob,
Yes absolutely, you can use front end expressions to achieve this, but I would not recommend you to do that as it would hamper your applications performance.
Thanks,
Sangram.