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: 
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])