Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
soniasweety
Valued Contributor III

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   

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Frank_Hartmann
Honored Contributor II

Re: percentage

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
Highlighted
soniasweety
Valued Contributor III

Re: percentage

Hi Sunny Talwar  any idea on this?

Highlighted
Partner
Partner

Re: percentage

sum(Value)

/

sum(TOTAL <Sales_Stage> Value)

This way you get the percentage value per Sales_Stage.

Highlighted

Re: percentage

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

Highlighted
soniasweety
Valued Contributor III

Re: percentage

Hi Sunny Talwar  this is expected output for the example

Highlighted
Frank_Hartmann
Honored Contributor II

Re: percentage

maybe like attached!

Highlighted
soniasweety
Valued Contributor III

Re: percentage

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.

Highlighted
Frank_Hartmann
Honored Contributor II

Re: percentage

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

For separat tables see attached

View solution in original post

Highlighted
soniasweety
Valued Contributor III

Re: percentage

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

Highlighted
Frank_Hartmann
Honored Contributor II

Re: percentage

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

see attached