Set Analysis applying max date scenario

[rt_new_user]

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:

Any ideas please.

Regards

RT

[jonathandienst · Accepted solution]

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)

[shiveshsingh · Accepted solution]

Include this in your set analysis

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

[rt_new_user]

Thanks

It worked!!

[rt_new_user]

 worked thanks!!