topic Re: Count if and Total in QlikView

Count if and Total

Wed, 26 Aug 2015 14:48:35 GMT

Hello everyone,

I have a table which contains an expression like :

count(if(A and B), Compteur)

Instead of the numbers, I would like to display the percentages in line, so divide each column by the total of the line. To do so, I wanted to use "Total" but i don't know how to use it with the "if"...

Count(if(A and B), Compteur)

(Please, I chose an if because I wasn"t able to do a proper set analysis.

Thank you for your help !

Re: Count if and Total

marcus_sommer — Wed, 26 Aug 2015 14:52:54 GMT

Try: Count(TOTAL <DIMENSIONS> if(A and B, Compteur))

If you provide more informations someone might help you with transform the if-loop into a set analysis statement.

- Marcus

Re: Count if and Total

Qrishna — Wed, 26 Aug 2015 14:56:56 GMT

Hi laura,

specify what the conditions A and B stand for.

Based on that we can write a set expression or an if() expression.

Usually A percentage can be calculated by :

Count(if(A and B), Compteur) / Count(total {$<set conditions >}Compteur) *100 and format the number accordingly

thanks