topic Chart Expression Normalization Error in QlikView

Chart Expression Normalization Error

Mon, 04 May 2009 11:30:31 GMT

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

Chart Expression Normalization Error

Mon, 04 May 2009 12:44:31 GMT

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%

Chart Expression Normalization Error

prieper — Mon, 04 May 2009 15:51:35 GMT

Hi,

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

/Peter

Chart Expression Normalization Error

Mon, 04 May 2009 22:27:26 GMT

Example posted, with brief description embedded.

Chart Expression Normalization Error

johnw — Tue, 05 May 2009 01:43:14 GMT

Is the attached what you're looking for?