topic set analysis problem in QlikView

set analysis problem

Thu, 30 Aug 2012 04:52:15 GMT

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.

whiteline — Thu, 30 Aug 2012 07:29:05 GMT

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)