Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis problem


if have used this expression for getting stock value of material that occur in alt_grp.

i just want that what expression should i used that i get stock of those material that occur in alt_grp as well as

stock of those material that do not occur in alt_group.


1 Reply
Master II
Master II

to invert alt_grp selection use:


if you have nulls in  alt_grp and want  include such values in the sum use something like this:

sum({1<max_month=$('v_inventory_Maxmonth'),plant=,material=> -