topic Aggr Count result on every rows in QlikView

Aggr Count result on every rows

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

Hello Everyone,

Need your help on the below output:

Raw Data:

Output Table:

To find out "Total" -- Need to group by Part, Order, Item then Count(Item)

I am using this expression but not getting result on every rows :

Expression : count(aggr(count(Item), Part, Order))

This is not showing exactly the above Output table result. --- I need this result on every rows on Total Column.

Taoufiq_Zarra — Mon, 19 Oct 2020 10:33:49 GMT

@rakeshkumar1890 in script or in chart ? and how you get for example this line ?

Wex

200

Campaign

rakeshkumar1890 — Mon, 19 Oct 2020 11:02:45 GMT

@Taoufiq_Zarra I need on chart and It should be distinct by Part, Order and Item

Brett_Bleess — Tue, 27 Oct 2020 20:37:46 GMT

I would venture you may need both Set Analysis and AGGR in this case, here are a couple of Design Blog posts that may be helpful:

Hopefully those may help.

Regards,
Brett

Kushal_Chawda — Tue, 27 Oct 2020 22:38:30 GMT

@rakeshkumar1890 you can go other way around by counting orders instead

=sum(total <Part,Item>aggr(Count(DISTINCT Order),Part,Item)) or =Count(DISTINCT total <Part,Item>Order)