topic Re: Calculating a rate in QlikView

Calculating a rate

Mon, 16 Nov 2015 14:36:59 GMT

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

Mon, 16 Nov 2015 14:47:59 GMT

can u share your expression

sunny_talwar — Mon, 16 Nov 2015 15:02:00 GMT

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

rwunderlich — Mon, 16 Nov 2015 15:02:37 GMT

I think it would be:

Dim: OUTCOME

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

-Rob

Edit: Forgot the fieldname!

Tue, 17 Nov 2015 15:31:04 GMT

Perfect - exactly what I was looking for!

Many thanks!