Discussion Board for collaboration related to QlikView App Development.
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
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
View solution in original post
=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.
Thanks a lot to both of you