Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
samvile18
Creator III
Creator III

Set Analysis Help...

Hi all,

I have the following set analysis which returns the attached table:

Count(Distinct{<IsAnnualReview={'N'}>}JourneyId)

Test tableTest table

I need to add a line to the expression so it only shows the max JourneySequence. I assumed it was a mixture off Aggr(Max but I cannot seem to get it to work properly. 

Any help would be greatly appreciated. 

Thanks in advance.

Labels (1)
3 Replies
Marcel_Garcia
Contributor II
Contributor II

Try this:
Max(Aggr(Count(Distinct{<IsAnnualReview={'N'}>}JourneyId)))

samvile18
Creator III
Creator III
Author

Sadly, it didn't like that at all...error on the expression with aggr needing 2 or more parameters.

samvile18
Creator III
Creator III
Author

**BUMP**