topic List box selection in QlikView

List box selection

Tue, 04 Sep 2012 00:17:11 GMT

Hi,

I want to restrict the user to not to select more than one value in the list box. But i dont want to use the always one selected value .

Re: List box selection

shree909 — Tue, 04 Sep 2012 04:45:41 GMT

hi,

go to the listbox and select one value, then goto the properties of the listbox and from general select one value

that\ works fine

Re: List box selection

Tue, 04 Sep 2012 04:48:42 GMT

Thanks for your response,but as i mentioned i dont want to use always one selected value since i want to clear it when navigating from one tab to another

Re: List box selection

shree909 — Tue, 04 Sep 2012 04:52:09 GMT

when u navigfate from from one tab to another , whatever u have in the current tab must be cleared.

this can be achieved by using bookmark.

the problem would be when u come back to the previous tab all your data will be cleared.

is that what something ur looking. then use the bookmark .

Re: List box selection

whiteline — Tue, 04 Sep 2012 04:58:50 GMT

First I thoght about Triggers, macros an so on...

But then I think I'v found a better and more stable solution:

Create a separate table with a new feild that contains exactly the same values.Now we have two fields. Let's name them 'NewField' and 'FieldToClear' correspondingly.

Then create list box with 'NewField' and check it to 'only one' selection. Since this field is not connected with others it will not affect your model.

Then you can use set analiysis in your expressions, for example:

Sum({$<FieldToClear=P(NewField)>} amount) - in expressions

=aggr(Only({$<FieldToClear=P(NewField)>} FieldToClear), FieldToClear) - as dimension instead of FieldToClear

Of course you should hide the field FieldToClear from user.