Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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

View solution in original post

multiview
Creator II
Creator II

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