topic Re: Set Analysis applying max date scenario in QlikView

Set Analysis applying max date scenario

rt_new_user — Sat, 16 Nov 2024 20:23:44 GMT

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

Re: Set Analysis applying max date scenario

jonathandienst — Wed, 24 Jul 2019 05:31:47 GMT

Like this:

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

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

Re: Set Analysis applying max date scenario

shiveshsingh — Wed, 24 Jul 2019 05:41:47 GMT

Include this in your set analysis

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

Re: Set Analysis applying max date scenario

rt_new_user — Wed, 24 Jul 2019 07:35:49 GMT

Thanks

It worked!!

Re: Set Analysis applying max date scenario

rt_new_user — Wed, 24 Jul 2019 07:36:33 GMT

worked thanks!!