topic Re: % of total count in QlikView

% of total count

ranibosch — Mon, 21 May 2018 12:24:40 GMT

good day,

i have the following data:

On my chart I basicallly want it to show me the % of each region's complaint.

Example:

Gauteng = 50% (which is 2 out of the 4 complaints)

i have 2 dimensions:

1. Complaint year

2. Origin of complaint

sunny_talwar — Fri, 25 May 2018 09:01:12 GMT

May be this

Count([Origin of Complaint])/Count(TOTAL [Origin of Complaint])

ranibosch — Mon, 28 May 2018 08:35:29 GMT

Hi Sunny,

Thanks for that, the formula you provided works if you want to look at the ratio in total, but not if you split it up into the "year" dimension.

Please find attached a detailed explanation of what I need.

Thank you! !

sunny_talwar — Mon, 28 May 2018 12:15:11 GMT

I guess Year is one of the dimensions, right? Try this

Count([Origin of Complaint])/Count(TOTAL <Year> [Origin of Complaint])

sunny_talwar — Mon, 28 May 2018 12:19:37 GMT

Sample image and qvw attached

ranibosch — Mon, 28 May 2018 14:08:31 GMT

Thanks Sunny, can I add a set analysis in front of this as well?

I have 2 types of entries:

1. Complaint

2. Inquiry

I was thinking something like this:

Count ( { < Type = {"Complaint"} > } ([Customer Compliant Ref#]))

Count ( { < Type = {"Complaint"} > } TOTAL <Year> ([Customer Compliant Ref#]))

sunny_talwar — Mon, 28 May 2018 16:35:49 GMT

Sure thing