topic Re: percentage in QlikView

percentage

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

Hi all i want to calucalte the % for the 3 measures based on dimension and i have type service and hadrware

Marco Wedel

tresesco

Andrea Gigliotti

dimension values

salestge

01-cust

02-vali

03-qua

04-dev..

05-negative....... like that

i want

service% = sum(01+02)/All_salestge = where type is service

hardware% = sum(01+02)/All_salestge = where type is hardware

total% = sum(01+02)/All_salestge

Re: percentage

soniasweety — Wed, 03 Oct 2018 13:38:35 GMT

Hi Sunny Talwar any idea on this?

Re: percentage

niclaz79 — Wed, 03 Oct 2018 13:57:35 GMT

sum(Value)

sum(TOTAL <Sales_Stage> Value)

This way you get the percentage value per Sales_Stage.

Re: percentage

sunny_talwar — Wed, 03 Oct 2018 13:58:05 GMT

What is the expected output in numerical terms for the sample data provided?

Re: percentage

soniasweety — Wed, 03 Oct 2018 14:03:08 GMT

Hi Sunny Talwar this is expected output for the example

Re: percentage

Frank_Hartmann — Wed, 03 Oct 2018 15:23:38 GMT

maybe like attached!

Re: percentage

soniasweety — Wed, 03 Oct 2018 15:28:51 GMT

instead of hard coding is there any other way to get dynamic?

and i want two seperate tables in attached image the same way they wanted to see

top table should have the totals

below it with percentages.

Re: percentage

Frank_Hartmann — Wed, 03 Oct 2018 15:38:14 GMT

I think Island Table is the best way to get the desired result.

For separat tables see attached

Re: percentage

soniasweety — Wed, 03 Oct 2018 15:52:41 GMT

it seems same way its looking .. i will test in my original dashboard and close the thread thank you good night

Re: percentage

Frank_Hartmann — Wed, 03 Oct 2018 17:19:32 GMT

maybe you can also try using calculated dimension to achieve desired output.

see attached