Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ranibosch
Creator
Creator

% of total count

good day,

i have the following data:

   

TypeComplain dateCustomer Compliant Ref#Origin of Complaint
Complaint31 Jul 1520150730-328805082Gauteng
Complaint30 Mar 1620160322-339979656KZN
Complaint30 Mar 1620160323-340012663Eastern Cape
Complaint14 Apr 1620160412-340904856Gauteng

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

stalwar1

1 Solution

Accepted Solutions
sunny_talwar

Sample image and qvw attached

Capture.PNG

View solution in original post

6 Replies
sunny_talwar

May be this

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

ranibosch
Creator
Creator
Author

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

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

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

sunny_talwar

Sample image and qvw attached

Capture.PNG

ranibosch
Creator
Creator
Author

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

Sure thing