Calculating a rate

[#1]

Hi,

I have had a slight mathematical block...  The attached file has 190 data entries which lists a 'Start Position' field of values I,N, S,

and a 'Outcome' field of 9 possibilities (values A-I)

I'm trying to display a bar chart for the Rate Outcomes of Start Position I but having no luck.  I need to show something like the following:

but when I attempt it in Qlikview each Outcome is at 100%

Any help appreciated.

Tom

[#2]

can u share your expression

[sunny_talwar]

How would you calculate Rate Outcome of Start Position in your Excel file?

[rwunderlich · Accepted solution]

I think it would be:

Dim: OUTCOME

Expr: count({<START_POSITION={'I'}>}OUTCOME) / count(TOTAL {<START_POSITION={'I'}>}OUTCOME)

-Rob

Edit: Forgot the fieldname!

[#5]

Perfect - exactly what I was looking for!

Many thanks!