Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Find max records in straight table then count matching

I have a tabular table in the format below loaded into my app

Package SeriesRecord IDPackage Phase Tracking IDPackage Phase ID
2019-00002890925471391
2019-00002891025481419
2019-00002991125561391
2019-00002991125581419

 

I am trying to produce a test straight table on a sheet of only the Max "Package Phase Tracking ID" in each "Package Series"

Package SeriesRecord IDPackage Phase Tracking IDPackage Phase ID
2019-00002891025481419
2019-00002991125581419

 

I'm not having much success using a measure of Max(total <[Package Series]> Aggr([Package Phase Tracking ID], [Package Series], [Record ID]))

The purpose of this is to then produce a bar chart that counts the resultant quantity of Package Phase IDs as a dimension

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

hi 

you can use this calculated dimension , 

=if([Package Phase Tracking ID]= aggr(nodistinct max([Package Phase Tracking ID]),[Package Series]),[Package Phase ID])

then use count(packge series) as measure for the bar chart  

View solution in original post

2 Replies
Highlighted
Partner
Partner

hi 

you can use this calculated dimension , 

=if([Package Phase Tracking ID]= aggr(nodistinct max([Package Phase Tracking ID]),[Package Series]),[Package Phase ID])

then use count(packge series) as measure for the bar chart  

View solution in original post

Highlighted
Contributor II
Contributor II

Thank you so much for this!  My only tweak was to add Distinct to the count of [Package Series] such that it didn't duplicate for my data set.