topic COUNT & IF in QlikView

COUNT & IF

Fri, 22 Oct 2010 11:47:46 GMT

Hi guys

I have the following formula that gives either the word GOOD or null.

What must I do in order to count where the below mentioned formula's result is GOOD?

if(((count(if(if((GRQuantity-POQuantity)>=0,GRDocDate-PODocDate,"")<=(PODueDate-PODocDate),'RECEIVED ON TIME',""))) / (count(distinct(ItemCode))))>=0.2,'GOOD')

Thank you

COUNT & IF

john_duffy — Fri, 22 Oct 2010 12:50:50 GMT

Hello.

Change the expressions Total Mode to Text Count of Rows.

John.

COUNT & IF

Fri, 22 Oct 2010 13:01:50 GMT

I am not sure what you mean. But all I know is that I need to change my formula in order to count the number of rows that gives the word 'GOOD'.

I can not get your solution to work, thanks anyway.

Thanks

COUNT & IF

john_duffy — Fri, 22 Oct 2010 13:12:21 GMT

Hello.

I have attached an application showing how the Text Count total mode will sum all rows with the value 'GOOD'. To change the total mode go to the Expressions tab in the chart properties and select Text count from the drop down list in the Total Mode section.

I'm assuming your expression is working fine and you just want to show the total number of rows with the value 'GOOD' on the chart.

John.

COUNT & IF

Fri, 22 Oct 2010 13:29:38 GMT

The total displays fine, but I need to use the formula in another formula.

Thus I need to know what to change in the formula.

Thank you

COUNT & IF

renjithpl — Fri, 22 Oct 2010 13:41:51 GMT

Hi,

If i understood your question,

Just Try

Sum(your code) just put zero instead of null and put one instead of 'Good')

Sum( if(((count(if(if((GRQuantity-POQuantity)>=0,GRDocDate-PODocDate, "")<=(PODueDate-PODocDate),'RECEIVED ON TIME',""))) / (count(distinct(ItemCode))))>=0.2, 1)

Regards