Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

How to show last report date KPI?

Hi,

I have a Sales measure where the dates are unevenly spaced. How can I create a KPI where the first measure is the sales of the current selection date and the second measure is the sales of the previous report date, conditional on the current selection date?

Thank you.

Tags (1)
3 Replies
santhoo_san
Contributor II

Re: How to show last report date KPI?

Create an id for each of the period you wish to view the KPI and apply your condition based on the ID

Not applicable

Re: How to show last report date KPI?

Hi Santhosh. Okay, I've created ID for each date. How can I create condition based on them? Thanks.

santhoo_san
Contributor II

Re: How to show last report date KPI?

Current Period:

Sum({<PeriodID={$(=Max(PeriodID))} >}Measure)


Previous Period:

Sum({<PeriodID={$(=Max(PeriodID)-1)} >}Measure)

Community Browser