topic Re: divide by count in a chart disregarding dimension in QlikView

divide by count in a chart disregarding dimension

Tue, 29 Apr 2014 10:07:01 GMT

Hello

I have a barchart with this expression

=Count({<FlagDays={'>0'}>} FlagDays) ---- This give me a total of 15

I then also use FlagDays as an dimension, and then i get the 15 spread out on this dimension.

Now i want to normalize these numbers, så i want to divide the result for each dimension with the total of 15

But how do i do that?

MK_QSL — Tue, 29 Apr 2014 10:16:43 GMT

=Count({<FlagDays={'>0'}>} FlagDays)/=Count({1<FlagDays={'>0'}>} FlagDays)

=Count({<FlagDays={'>0'}>} FlagDays)/=Count(TOTAL {<FlagDays={'>0'}>} FlagDays)

rbecher — Tue, 29 Apr 2014 10:16:58 GMT

Hi Thomas,

have you tried:

=Count({<FlagDays={'>0'}>} FlagDays) / Count(TOTAL {<FlagDays={'>0'}>} FlagDays)

- Ralf