Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

Tags (3)
1 Solution

Accepted Solutions

Re: count if is not null

May be this

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

1 Reply

Re: count if is not null

May be this

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

Community Browser