topic Re: Making a list box ignore a specific selection in QlikView

Making a list box ignore a specific selection

Wed, 17 Sep 2014 13:54:05 GMT

Hi all,

I'm sure there's a very simple solution to this, but I can't find one anywhere on here.

Basically, I have a Field (Period) that always has to have a selected value (this must remain the case).

This has not been an issue in other parts of my document as I've been able to use sum({<Period>}.......) to make any sums I've used ignore this selection.

However, I now need to display a Field (Cost Centre Manager Comments) in a list box, and have that ignore the selected value from Period, and I can't use sum as it isn't actually summing anything, it's just displaying the Field data.

Basically I need a list box expression so that this field is displayed , ignoring the specific Period selection (whilst not ignoring any other selections)

Thanks in advance

Re: Making a list box ignore a specific selection

shane_spencer — Wed, 17 Sep 2014 14:03:06 GMT

I use something similar to show the values I want (rather than not show those I don't) using match

i.e.

=if( match(Server,'GBW05041', 'GBW05042'), Server)

n.b. Server is the Field I'm showing and 'GBW05041' and 'GBW05041' are values in that field.

Re: Making a list box ignore a specific selection

Gysbert_Wassenaar — Wed, 17 Sep 2014 14:05:38 GMT

Create an alternate state (e.g. AltState1) for your Period field, assign the listbox for Period to that alternate state and use in your set analysis expressions Period={AltState1}::Period where you want to use the selection in the Period listbox in the alternate state.

Re: Making a list box ignore a specific selection

MK_QSL — Wed, 17 Sep 2014 14:05:54 GMT

Better if you provide few line sample data for this question.. ;Thanks