topic Find max records in straight table then count matching in QlikView

Find max records in straight table then count matching

Delestia — Sat, 16 Nov 2024 18:19:50 GMT

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

lironbaram — Wed, 22 Jul 2020 15:25:47 GMT

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

Delestia — Wed, 22 Jul 2020 16:14:18 GMT

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.