Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

count if is not null

hi,

I have this .csv file:

ID product            quantity

        1                        123

        2                        456

        3                        789

        4                        Null

        5                        852

My problem is that I want to find a way to count, in a table, ID product only if the quantity is not Null

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

May be this

Count(DISTINCT {<quantity = {'*'}>} [ID product])

View solution in original post

1 Reply
sunny_talwar

May be this

Count(DISTINCT {<quantity = {'*'}>} [ID product])