Displaying Latest Week Data

[#1]

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

[reddy-s]

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.

[#3]

Hi Sangram,

Appreciate the prompt response.

Is there around this without having to use a 'Master Calendar'?

Thanks,

Jacob

[reddy-s]

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.