Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis problem

sum({<alt_grp=p(alt_grp),max_month=$('v_inventory_Maxmonth'),plant=,material=>}stock)

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
whiteline
Master II
Master II

to invert alt_grp selection use:

sum({<alt_grp=e(alt_grp),max_month=$('v_inventory_Maxmonth'),plant=,material=>}stock)

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=> -

         $<max_month=$('v_inventory_Maxmonth'),plant=,material=>}stock)