Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

divide by count in a chart disregarding dimension

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?

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: divide by count in a chart disregarding dimension

Hi Thomas,

have you tried:

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

- Ralf

2 Replies

Re: divide by count in a chart disregarding dimension

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


or


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


MVP
MVP

Re: divide by count in a chart disregarding dimension

Hi Thomas,

have you tried:

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

- Ralf

Community Browser