topic Re: Count IF in QlikView

Count IF

upaliwije — Sun, 16 Mar 2014 09:59:37 GMT

Hi Friends

I have a pivot table with following fields

Item_No, Purchase Date....

I want to create a expression to count item no if purchase date is not null

Count(Item_No) how can I include condition 'IF PURCHASE DATE IS NOT NULL'

pla help me

cgdonders — Sun, 16 Mar 2014 10:13:11 GMT

Hi,

You can use the isnull() function for this:

Count( IF(isnull(purchase date)=0, item no) )

Isnull: 0 if field is not null, -1 if field is null

swuehl — Sun, 16 Mar 2014 10:14:50 GMT

Maybe

=count( if(len(trim([Purchase Date])), Item_No))

But to understand your problem correctly, it might be helpful if you could upload a small sample application.

upaliwije — Sun, 16 Mar 2014 10:20:14 GMT

Thanks a lot to both of you