topic Re: Calculated Percentages in QlikView

Calculated Percentages

Tue, 03 Sep 2013 10:03:29 GMT

Hi All,

My first post, I hope it's a simple problem for somebody.

I'm analysing some data using Qlikview and need percentages that will always equal 100% even when I filter using a list box...

for example here is some data.

Location Gender

UK Male

US Male

UK Male

US Female

I have a simple bar chart with Location as the X axis, and percentage of the sample on the Y axis.

That chart will show 40% are from the UK and 60% are from the US.

I have a list box with gender, and I choose to show only males.

The percentages will need to update to show 50% UK and 50% US.

I've had a bit of a play around but not been able to solve this.

Any assistance would be really appreciated.

Andrew

Re: Calculated Percentages

Gysbert_Wassenaar — Tue, 03 Sep 2013 10:09:19 GMT

Add Location as dimension and count(Gender) as expression and enable the option Relative for the expression. If you select Male in the listbox the percentages will show 50% for both locations. See attached example.

Re: Calculated Percentages

tresB — Tue, 03 Sep 2013 10:12:18 GMT

PFA

Re: Calculated Percentages

Tue, 03 Sep 2013 10:19:08 GMT

Massive thanks, very quick response, really helpful

Re: Calculated Percentages

Tue, 03 Sep 2013 10:19:35 GMT

great, thanks for getting back so quickly, really helpful, problem solved