Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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

Thanks a  lot to both of you