topic Re: Using percentage for multiple dimentions in a chart. in QlikView

Using percentage for multiple dimentions in a chart.

kstroupe — Mon, 06 May 2013 22:13:45 GMT

Hello,

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

Area	Facility	Dept	Util Cnt	TTL	Percentage
Property	208	129	765	917	.83
Property	208	137	70	3979	.02
Property	308	410	2775	6801	.41
Property	308	412	0	5	0
Jam	408	124	758	1478	.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

Re: Using percentage for multiple dimentions in a chart.

kstroupe — Mon, 06 May 2013 22:16:01 GMT

Sorry the Chart I am looking for is a bar chart

Re: Using percentage for multiple dimentions in a chart.

kstroupe — Mon, 06 May 2013 22:16:09 GMT

Sorry the Chart I am looking for is a bar chart

Re: Using percentage for multiple dimentions in a chart.

Gysbert_Wassenaar — Tue, 07 May 2013 06:27:47 GMT

See attached example.

Re: Using percentage for multiple dimentions in a chart.

kstroupe — Tue, 07 May 2013 14:28:46 GMT

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