Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Displaying Latest Week Data

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

3 Replies
reddys310
Honored Contributor II

Re: Displaying Latest Week Data

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.

Not applicable

Re: Displaying Latest Week Data

Hi Sangram,

Appreciate the prompt response.

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

Thanks,

Jacob

reddys310
Honored Contributor II

Re: Displaying Latest Week Data

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.

Community Browser