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: 
kstroupe
Creator
Creator

Using percentage for multiple dimentions in a chart.

Hello,

This is my first post and I am a newborn to Qlikview.  I have data in a table that looks like

AreaFacilityDeptUtil CntTTLPercentage
Property208129765917.83
Property208137703979.02
Property30841027756801.41
Property308412050
Jam4081247581478.51

What I am trying to do is to allow the user to see a chart where the area's are listed and a percentage for each area

Property = 31% (sum of all Util/TTL for Dimention Area = Property)

Jam = 51%

Then when I click on Dimention (Area) I would like to see chart for Dimention Facility 208 and 308

208 = 17% (sum of Util/TTL for Dimention Facility = 208)

308 = 41%

And last Click on Dimention 208 Facility and see Dept

129 = 83% (Sum of Util/TTL for Dimention Dept = 129

137 = 2%

Any help is appreciated... Thanks Kim

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
kstroupe
Creator
Creator
Author

Sorry the Chart I am looking for is a bar chart

Capture.JPG

kstroupe
Creator
Creator
Author

Sorry the Chart I am looking for is a bar chart

Capture.JPG

Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand
kstroupe
Creator
Creator
Author

Yep that worked perfectly.  Thank you so much.   I thought I had something like that but for some reason yours worked and mine didn't.  I'm gonna look at your example closer and try to figure out what was different, but I really appreciate your help and quick response.

Thanks

Kim