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: 
Not applicable

Chart Expression Normalization Error

I've got a bar chart that shows recommendataions 1 and 2 out of a possible 1 through 5, by gender, so there are two dimensions (gender and rating). Now I need to normalize the values..

This expression gives the count: If(Recommend<=2,Count(Recommend)) and this is the normalization: If(Recommend<=2,Count({1}Recommend))

Both expressions give correct values if they are charted independently, but if I combine them on a single chart to do the normalization, they do not: If(Recommend<=2,(Count(Recommend)/Count({1}Recommend))*100)

Any suggestions? Thanks, Tom

4 Replies
Not applicable
Author

I've figured out the problem but not the solution. Let's say you have:

10 out of 100 recommendations are 1 or 2, by males, which is 10%

15 out 100 recommendations are 1 or 2, by females, which is 15%

The formulas above calculate the total by adding 10% and 15% for 25%. I really want 25 out of 200 for a total, which is 12.5%

prieper
Master II
Master II

Hi,

can you post an example? Might be a bit easier to look at.

/Peter

Not applicable
Author

Example posted, with brief description embedded.

johnw
Champion III
Champion III

Is the attached what you're looking for?