topic Re: Pick Match() and Aggr Count in QlikView

Pick Match() and Aggr Count

nabilbrahimi — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have an issue to display value desired with pick match().

I would like to display the total number of unique trucks , in my case I have 47 from Jan. to Apr.

sum(aggr(Count(DISTINCT {<OWN_ship_flag = {"1"} >} Plate_num),Month))

When I use same formula with Pick Match() I have no result:

pick(match(Truck_KPI,'Own Truck Utilization'),

sum(aggr(Count(DISTINCT {<OWN_ship_flag = {"1"} >} Plate_num),Month)) )

with NODISTINCT qualifier I have a result but not the figure I'm expecting which is 47.

Can someone help?

Thank you!

sunny_talwar — Thu, 24 Aug 2017 15:36:30 GMT

This is an issue and you can read related stuff here

May be try this

Pick(Match(Truck_KPI,'Own Truck Utilization'), Count(TOTAL DISTINCT {<OWN_ship_flag = {"1"} >} Plate_num))

nabilbrahimi — Fri, 25 Aug 2017 08:50:17 GMT

Hi Sunny,

Thanks for the tip, unfortunately TOTAL does not help....

However by adding synthetic dimension name in group by solved the issue:

pick(match(Truck_KPI,'Own Truck Utilization'),

sum(aggr(Count(DISTINCT {<OWN_ship_flag = {"1"} >} Plate_num),Month, Truck_KPI)) )