Help with ignoring selections using {1}

[mellerbeck]

I've been having trouble getting a chart to ignore selections.

This is the expression in the chart. Any thoughts on what I should do?

=sum(Aggr(if(PO_HDR.Plant = '03',if(PO_HDR.DueDate = vSelectedDate,PO_HDR.PalletCount)), PO_HDR.in_item_key, Order))

[mellerbeck]

i.e. if you click on an Order row the Pallet graph should not change.

[swuehl · Accepted solution]

You could try set expressions to clear the selection in Order field:

=sum({<Order=>} Aggr(if(only({<Order=>}PO_HDR.Plant) = '03',if(only({<Order=>}PO_HDR.DueDate) = vSelectedDate,only({<Order=>}PO_HDR.PalletCount) )), PO_HDR.in_item_key, Order))

Regards,

Stefan

[mellerbeck]

Thanks a lot Stefan! Exactly what I needed. I also started messing with alternative states! That is cool stuff!