Announcements
Sept. 27, 10AM ET Do more with Qlik, Insight Advisor – our intelligent AI-assistant in Qlik Sense: Register
cancel
Showing results for
Did you mean:
Contributor III

## Set Analysis applying max date scenario

Hi QV users

I am struggling to come up with an expression which meets the requirement.

I want to apply set analysis to the most recent date plus some other conditions. This expression below which iam using satisfies my other conditions. But idon't know how to add max date condition to this.

sum({<KPI_Name={'1.unique*'},TECHNOLOGY={'RIS'}>} DATA_VALUE)

The above gives me sum of Data_Value, when KPI_Name equals '1.unique_roamers' and TECHNOLOGY = 'RIS'

I want to apply the above with an additional condition which only takes into account the most recent date:

Regards

RT

Labels (1)
• ### max Date in Set Analysis

2 Solutions

Accepted Solutions
Partner - Champion III

Like this:

sum({<Date={\$(=Max(Date))},KPI_Name={'1.unique*'},TECHNOLOGY={'RIS'}>} DATA_VALUE)

or

sum({<Date={"\$(=Max(Date))"},KPI_Name={'1.unique*'},TECHNOLOGY={'RIS'}>} DATA_VALUE)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Master

Include this in your set analysis

Date={"\$(=Max(Date))"}

4 Replies
Partner - Champion III

Like this:

sum({<Date={\$(=Max(Date))},KPI_Name={'1.unique*'},TECHNOLOGY={'RIS'}>} DATA_VALUE)

or

sum({<Date={"\$(=Max(Date))"},KPI_Name={'1.unique*'},TECHNOLOGY={'RIS'}>} DATA_VALUE)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Master

Include this in your set analysis

Date={"\$(=Max(Date))"}

Contributor III
Author

Thanks

It worked!!

Contributor III
Author

worked thanks!!

Community Browser