topic List Box (With 1 fixed selection & 1 mandatory Selection) in QlikView

List Box (With 1 fixed selection & 1 mandatory Selection)

Wed, 10 Dec 2014 12:57:35 GMT

Hello,

I would like to create a list box with 1 fixed selection & 1 mandatory Selection.

Eg. List Box has following Selection

I would like to have "E" locked all the time regardless of other selections, and user must select one of A - D on top of E.

Is there any possibility to do that?

Thank you.

Re: List Box (With 1 fixed selection & 1 mandatory Selection)

arulsettu — Wed, 10 Dec 2014 13:01:15 GMT

select E and go to properties then in general enable always one selected value

Re: List Box (With 1 fixed selection & 1 mandatory Selection)

jonathandienst — Wed, 10 Dec 2014 13:10:49 GMT

Right click on 'E' in the list box and select Lock.

HTH

Jonathan

Re: List Box (With 1 fixed selection & 1 mandatory Selection)

Wed, 10 Dec 2014 13:20:07 GMT

Hi Arul,

By utilizing that, I can only select E but not E + (One of A - D) on top of E.

Any other way to do it?

Re: List Box (With 1 fixed selection & 1 mandatory Selection)

Wed, 10 Dec 2014 13:20:59 GMT

HI Jonathan, by locking the list box, I cannot add One of A - D on top of E.

Re: List Box (With 1 fixed selection & 1 mandatory Selection)

Wed, 10 Dec 2014 13:22:22 GMT

select E> and goto selections(in main tab)>click on set clear state

if u clear also e selections will be there till u click on reset clear state which is avaliable in same location

Re: List Box (With 1 fixed selection & 1 mandatory Selection)

Wed, 10 Dec 2014 14:33:06 GMT

Tried that option but when I clear selections, the selected E disappears as well

Re: List Box (With 1 fixed selection & 1 mandatory Selection)

Wed, 10 Dec 2014 14:37:21 GMT

Hi ashley,

i dont think so.

click on E > click on set clear state

i think it should work

Re: List Box (With 1 fixed selection & 1 mandatory Selection)

Thu, 11 Dec 2014 01:52:13 GMT

Hi Manojqlik, Yes, I clicked on E and it is appearing in my Current Selections screen.

Then I went to Selections -> Set clear State

But when I click on clear all later, E disappears from my current selections screen.

To my understanding, it should still remain there right?

Re: List Box (With 1 fixed selection & 1 mandatory Selection)

Michiel_QV_Fan — Thu, 11 Dec 2014 07:33:49 GMT

Ashley,

Do this in your expressions:

sum({<your_field = {'E'}>}measure) + sum({< your_field = {'$(=GetFieldSelections(your_field ))'}>} measure)

you can always add this to a variable and add the variable to the set analyses with {<$(your_variable)>}