Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

percentage

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   

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

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

For separat tables see attached

View solution in original post

9 Replies
soniasweety
Master
Master
Author

Hi Sunny Talwar  any idea on this?

niclaz79
Partner - Creator III
Partner - Creator III

sum(Value)

/

sum(TOTAL <Sales_Stage> Value)

This way you get the percentage value per Sales_Stage.

sunny_talwar

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

soniasweety
Master
Master
Author

Hi Sunny Talwar  this is expected output for the example

Frank_Hartmann
Master II
Master II

maybe like attached!

soniasweety
Master
Master
Author

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.

Frank_Hartmann
Master II
Master II

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

For separat tables see attached

soniasweety
Master
Master
Author

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

Frank_Hartmann
Master II
Master II

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

see attached