Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Only one value can be selected from the listbox

Can we restrict only one value to be selected from the listbox  .....????

21 Replies
SunilChauhan
Champion
Champion

yes in list box select one value

and go to general in charts properties-> select always one select value

hope this helps

Sunil Chauhan
jagan
Luminary Alumni
Luminary Alumni

Hi,

You can do this by

1. Select single value in the List box.

2. Select Properties -> General -> Always One Selected value option

Hope this helps you.

Regards,

Jagan.

Anonymous
Not applicable
Author

But the problem with this is that you can never clear the field. /Marcus

siva_boggarapu
Creator II
Creator II

Hello There,

I am also having same problem, but in my case "Always One Selected value option" is in Disable. How can I enable this?

Best,

Siva.

swuehl
MVP
MVP

Siva,

This option is only available after you selected exactely one single value.

IAMDV
Luminary Alumni
Luminary Alumni

Hi Marcus,

I had created a video post on how to clear "Always One Selected Value". Please check this video post :

http://qlikshare.com/221

Cheers,

DV

jagan
Luminary Alumni
Luminary Alumni

Hi Siva,

Please check attached file.  Hope this is what you are expecting.

Regards,

Jagan.

IAMDV
Luminary Alumni
Luminary Alumni

Hi All,

Jagan's solution should suffice. However, I try to avoid using triggers as much as possible. So if you wanted to acheive the same functionality then you use this expression :

=IF(GetSelectedCount(Year) = 0, Year, Aggr(MAX({<Year ={$(=FirstSortedValue( Year, -Year))}>} Year), Year))

Ofcourse, you can change the logic to select appropriate Year when the user selects multiple values. In this example, I'm using the max Year.

I hope this makes sense.

Good luck!

Cheers,

DV

www.QlikShare.com

swuehl
MVP
MVP

DV,

I think your solution using an expression in the list box is not showing the same  functionality, since it's only limiting the values shown in this single list box. If you select more than one value, these values will actually be selected (and affect other objects / results). And I believe you can't change this behaviour just by using a list box expression field.

Regards,

Stefan