Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

mellerbeck
Contributor II

Help with ignoring selections using {1}

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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Help with ignoring selections using {1}

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

3 Replies
mellerbeck
Contributor II

Help with ignoring selections using {1}

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

MVP
MVP

Re: Help with ignoring selections using {1}

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
Contributor II

Help with ignoring selections using {1}

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

Community Browser