Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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:

Setanalysis.jpg

 

Any ideas please.

Regards

RT

 

 

Labels (1)
2 Solutions

Accepted Solutions
Highlighted

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

View solution in original post

Highlighted
Master
Master

Include this in your set analysis

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

View solution in original post

4 Replies
Highlighted

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

View solution in original post

Highlighted
Master
Master

Include this in your set analysis

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

View solution in original post

Highlighted
Contributor III
Contributor III

Thanks

It worked!!

Highlighted
Contributor III
Contributor III

 worked thanks!!