Making alternate state choices not include default state selections?
Hello, In the "Sale Overlap" sheet of the "What's New in Qlikview 11" QVW, how can I make the Group 1 box not contain any of the same products selected in the default state? I think I'm close but cannot come up with the proper syntax. I've tried every variation of ={1-$}::[Product Sub Group] that I can think of. Thank you, -david
Are you talking about the selection list box for Group 1?
If you want to limit the displayed items to only the items excluded by the possible selection of Base or default state group, you could use an expression for the list box field (on general tab in the list box, field selector, at the bottom there is an <Expression> that you can select and modify):
=aggr(only({<[Product Sub Group] = e($::[Product Sub Group]) >} [Product Sub Group]),[Product Sub Group])
If you are talking about the charts for invoice and sales above the list boxes, I think something similar using e($::[Product Sub Group]) should also do. I am not quite clear what you are after.
