AGGR in Chart

geam1988 — Thu, 01 Apr 2021 10:54:50 GMT

Hi, I have a table like this

I want to have report like this

but i am not able to get the proper result in QLikView report.

Qlikview report

i am using following expressions for Group value =

if i write the expressions as Calculated dimension. that works fine. but with that i can not get %. I can do group by in Load script but i want to do it in Chart. Is it possible? Any suggestion will be highly appreciated.

Thank

Kazi

Re: AGGR in Chart

Frank_Hartmann — Thu, 01 Apr 2021 11:23:08 GMT

Dimension:

Sales Person

Exp for "Group value as Expression"

sum(aggr(sum(Total <Group> [Sales Value]), Group,[Sales Person]))

Exp for "%":

sum([Sales Value]) / sum(aggr(sum(Total <Group> [Sales Value]), Group,[Sales Person]))

topic Re: AGGR in Chart in QlikView

AGGR in Chart

Re: AGGR in Chart