topic Count with if condition in QlikView

Count with if condition

Tue, 13 Sep 2016 08:59:42 GMT

I have an expression that is wrong, but should show what I want to do:

COUNT(

if(((SUM(krankstunden_netto)/SUM(sollstunden_netto))*100)=0,1,0)

)

I want to count the value 1 when the result of the expression is 0

How do I do this correctly in Qlikview?

Thu, 19 Jan 2017 23:14:00 GMT

Try something like:

Count({<Stock_Code = {"=if(((SUM(krankstunden_netto)/SUM(sollstunden_netto))*100)=0,1)"}>}Stock_Code)

Replace Stock_Code with your own field

Fri, 20 Jan 2017 06:31:34 GMT

Perhaps creating a flag in the back end using the same logic, then counting where field = 0 in the set analysis.

Good Luck,

Pravesh