Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Count IF

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

1 Solution

Accepted Solutions
cgdonders
Partner
Partner

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

View solution in original post

3 Replies
cgdonders
Partner
Partner

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

View solution in original post

swuehl
MVP
MVP

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
Creator II
Creator II
Author

Thanks a  lot to both of you