Add/take-away values

[#1]

Hi everyone,

I have a list of orders by company. I want to be able to select some orders to exclude, show the excluded values in another list box, and then be able to choose some of those excluded orders to add back to the selection.

E.g.

Orders	Excluded
A
B
C
D

Select C+D to exclude

Orders	Excluded
A	C
B	D

Then select D to include again, but leave C out:

Orders	Excluded
A	C
B
D

[MK_QSL]

For selected use below in List Box expression

=IF(GetFieldSelections(Orders) > 0 ,Aggr(Orders,Orders))

[#3]

Thanks Manish. Any idea about the rest?

[#4]

Does anyone else have an idea for this? Or is it a capability not native to Qlikview?

[MK_QSL · Accepted solution]

For Selected

=IF(GetFieldSelections(Orders) > 0 ,Aggr(Orders,Orders))

For Not Selected

=aggr(only({1-$} Orders),Orders)

[Anonymous]

See if this helps...

[#7]

Thank you so much. Both work great. But it's a shame that to add excluded values back to the selection, I can't just ctrl+click that calculated list box - if I do, it erases my current selections and replaces them with the new one. Instead, I have to ctrl+click the original list box. This is fine, but 2 list boxes would be better than three...

Anyway, thanks!