Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

mjacobsen
New Contributor

{1} Set analysis reacting to selections.

I'm trying to make a KPI show the amount of cases for the latest month, however the below expression returns a count of unique_id for the current selection instead. Can anyone tell me what I'm doing wrong?

Count({1<YEAR_MONTH={"=Max(YEAR_MONTH)"}>} UNIQUE_ID)

Thank you.

1 Solution

Accepted Solutions
MVP
MVP

Re: {1} Set analysis reacting to selections.

Add {1} to the set modifier's Max() function also...

Also, do you may be also need a dollar sign expansion here?

Count({1<YEAR_MONTH={"$(=Max({1}YEAR_MONTH))"}>} UNIQUE_ID)

2 Replies
MVP
MVP

Re: {1} Set analysis reacting to selections.

Add {1} to the set modifier's Max() function also...

Also, do you may be also need a dollar sign expansion here?

Count({1<YEAR_MONTH={"$(=Max({1}YEAR_MONTH))"}>} UNIQUE_ID)

mjacobsen
New Contributor

Re: {1} Set analysis reacting to selections.

Thank you!

It works exactly the way I wanted.