Expression works only with dimension in table

[qlikviewaf]

Hi,

i have the following table.

The backorder expression is:

If(Match(OrderStatus,'900540','914999','904550','914550','904540'),if(vExcludeInstrumentSales,sum({<Year=,Month=,Quarter=,Day=,Invoice_Date_Num=,Invoice_Date=,Item_Category={$(vNoInstruments)}>}DistPOExtendedUSD),Sum({<Year=,Month=,Quarter=,Day=,Invoice_Date_Num=,Invoice_Date=,Item_Category={$(vNoInstruments)}>}DistPOExtendedUSD)),0)

and this formula is working ONLY if on the table the dimension OrderStatus is available - if i remove the dimension order-status, doesn't work. Anyone knows how i can fix this?

Thank you!

[sunny_talwar]

May be try this

Sum({<Year, Month, Quarter, Day, Invoice_Date_Num, Invoice_Date, Item_Category = {$(vNoInstruments)}>} Aggr(

If(Match(OrderStatus,'900540','914999','904550','914550','904540'), If(vExcludeInstrumentSales, Sum({<Year, Month, Quarter, Day, Invoice_Date_Num, Invoice_Date, Item_Category = {$(vNoInstruments)}>} DistPOExtendedUSD), Sum({<Year, Month, Quarter, Day, Invoice_Date_Num, Invoice_Date, Item_Category = {$(vNoInstruments)}>} DistPOExtendedUSD)), 0)

, OrderStatus))