topic Ignore Selections in ListBox without expression in QlikView

Ignore Selections in ListBox without expression

michael_maeuser — Wed, 06 Jun 2012 18:29:36 GMT

Hi,

I have a CM calculation that show actual vs. plancalc. For the plancalc exists a field that gives a certain calculation version. the whole plancalculation is not related to the calendar. so if i select a certain month i can´t select a plancalc version anymore. i know how to ignore dimensions with set analysis. but in this case i don´t have a sum expression or anything else. so i can´t use set analysis. can anyone help? Thanks!

Ignore Selections in ListBox without expression

swuehl — Wed, 06 Jun 2012 18:38:40 GMT

Really not sure if I understand your setting, some sample lines of data might help.

I assume you are displaying the version somewhere just by using [plancalc version] (plain field name)?

Try using only() function which will allow a set expression:

=only({<FIELDTOCLEARSELECTIONON=>} [plancalc version])