Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
chriscools
Creator II
Creator II

% vs total in pivot table only on row dimension

Hello,

i have a pivot table in qlikview with an expression that gives met the % vs total for sales :

sum({<Year={2021}>}qty_unit_delivered*price_net_computed)/sum(total{<Year={2021}>}qty_unit_delivered*price_net_computed)

it works correct  as long as for example i have only dimension on the left side.

If i put the agent on the left side then it gives met the % from total for each agent.

But now i want a different visualisation where i want the agent on the left side and sales channel on top.

And i would like to compare the % for each segment between the agents.

So i need that the calculated % on the row of the agent each time is 100 %.

And with the expression above it takes the whole tabel across al the agents and channels as 100 %:

chriscools_1-1646925897750.png

I'm not sure on how to adapt the expression for this.

Someone who can help me with it?

 

thanx

 

Chris

 

 

Labels (1)
0 Replies