Discussion board where members can get started with QlikView.
I have a tabular table in the format below loaded into my app
I am trying to produce a test straight table on a sheet of only the Max "Package Phase Tracking ID" in each "Package Series"
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
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
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.