Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rt_new_user
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
jonathandienst

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

shiveshsingh
Master
Master

Include this in your set analysis

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

View solution in original post

4 Replies
jonathandienst

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

shiveshsingh
Master
Master

Include this in your set analysis

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

View solution in original post

rt_new_user
Contributor III
Contributor III
Author

Thanks

It worked!!

rt_new_user
Contributor III
Contributor III
Author

 worked thanks!!