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

condition "is not null" or "is null" in sum

Hi !

is anyone know is it posible to fill condition isnull(fieldname) inside dimention condition:

i try to build somethng like this:

=sum({<bg_t={isnull(bg_t)},id=>} Quantity)

but it does't work

1 Solution

Accepted Solutions
Gysbert_Wassenaar

try this instead:

=sum({<bg_t-={'*'},id=>} Quantity)


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

try this instead:

=sum({<bg_t-={'*'},id=>} Quantity)


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

You try to put isnull() inside double qoutation marks ".

E.g

=sum({$<Customer={"=isnull(Address)"}>} Customer)

Regards

MultiView

Not applicable
Author

thank you !!!!!

Not applicable
Author

thank you, Multi View !!!

=sum({<bg_t-={"=isnull(bg_t)"},id=>} Quantity_i)

i tis also works