topic Re: Add/take-away values in QlikView

Add/take-away values

Thu, 26 Mar 2015 19:35:50 GMT

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

Re: Add/take-away values

MK_QSL — Thu, 26 Mar 2015 19:59:52 GMT

For selected use below in List Box expression

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

Re: Add/take-away values

Thu, 26 Mar 2015 21:01:17 GMT

Thanks Manish. Any idea about the rest?

Re: Add/take-away values

Fri, 27 Mar 2015 12:53:13 GMT

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

Re: Add/take-away values

MK_QSL — Fri, 27 Mar 2015 12:59:18 GMT

For Selected

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

For Not Selected

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

Re: Add/take-away values

Anonymous — Fri, 27 Mar 2015 13:02:50 GMT

See if this helps...

Re: Add/take-away values

Fri, 27 Mar 2015 13:44:51 GMT

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!