topic Help with ignoring selections using {1} in QlikView

Help with ignoring selections using {1}

mellerbeck — Mon, 26 Jan 2026 18:19:17 GMT

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

Help with ignoring selections using {1}

mellerbeck — Tue, 22 May 2012 21:13:55 GMT

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

Re: Help with ignoring selections using {1}

swuehl — Tue, 22 May 2012 21:31:17 GMT

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

Help with ignoring selections using {1}

mellerbeck — Tue, 22 May 2012 22:12:44 GMT

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