Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
aaronnayan
Contributor III

Set analysis include date selection

Hi guys

I want to create a KPI, to show last month sales, however when selections are made it should show the selected months sales.

I have created a date field to show the last month

SUM({<DATESORT={-1}>}Sales)

However If i select DATEMONTH, I want the above expression to be dynamic and change to the selected month.

Any ideas?

THanks,

Aaron

1 Reply

Re: Set analysis include date selection