topic Re: Contribution % in QlikView

Contribution %

Lalita_Rai — Wed, 03 Nov 2021 04:38:40 GMT

Hi,

How do I do this?

The question given (show contribution % to sales of each Employee in the dept )

Thank you so much.

LOAD * INLINE [

DeptID, Employee, Price, Quantity
101, Tom, 10, 1
101, Sara, 100, 2
101, Maya, 350, 7
102, Carl, 450, 4
102, Martha, 560, 6
103, Layra, 450, 7
103, Ten, 320, 4
103, Mark, 560,3
];

Re: Contribution %

rubenmarin — Thu, 04 Nov 2021 07:11:46 GMT

Hi, if you have a table with DeptID and Employee as dimensions you can use this expression:

Sum(Price*Quantity)/Sum(TOTAL <DeptID> Price*Quantity)

Re: Contribution %

Lalita_Rai — Fri, 05 Nov 2021 01:12:46 GMT

Thank you Ruben.

But I am not getting it in percent.

Below is the outcome I am suppose to get.

Many Thanks.

Re: Contribution %

Lisa_P — Fri, 05 Nov 2021 01:41:26 GMT

Just go to Number tab of Straight table and format fixed to 1 decimal place and tick the box show in percent%

Re: Contribution %

Lalita_Rai — Fri, 05 Nov 2021 01:52:41 GMT

Got it .Thank you so much!

Re: Contribution %

Lalita_Rai — Fri, 05 Nov 2021 01:53:18 GMT

Hi Ruben. I got the answer. Thank you for your help:)