Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

display null as zero for aggr

I have the following expression

=if(AGGR(Stock, [Code Article]) = 0, [Code Article])

I need to display code Article for which stock =0 or stock is null, how to correct it ?

1 Solution

Accepted Solutions
Kushal_Chawda

You need to use aggregation function to use AGGR

aggr(if(sum(Stock) = 0, [Code Article]),[Code Article])

View solution in original post

2 Replies
Kushal_Chawda

You need to use aggregation function to use AGGR

aggr(if(sum(Stock) = 0, [Code Article]),[Code Article])

sunny_talwar

Another option is to use this:

=Aggr(Only({<[Code Article] = {"=Sum(Stock) = 0"}>} [Code Article]), [Code Article])