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

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)