topic Only one value can be selected from the listbox in QlikView

Only one value can be selected from the listbox

Thu, 12 Apr 2012 06:55:53 GMT

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

Only one value can be selected from the listbox

SunilChauhan — Thu, 12 Apr 2012 07:45:33 GMT

yes in list box select one value

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

hope this helps

Only one value can be selected from the listbox

jagan — Fri, 13 Apr 2012 14:36:06 GMT

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.

Only one value can be selected from the listbox

Anonymous — Fri, 13 Apr 2012 14:48:53 GMT

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

Only one value can be selected from the listbox

siva_boggarapu — Mon, 04 Jun 2012 06:59:41 GMT

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.

Only one value can be selected from the listbox

swuehl — Mon, 04 Jun 2012 09:41:35 GMT

Siva,

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

Re: Only one value can be selected from the listbox

IAMDV — Mon, 04 Jun 2012 10:32:10 GMT

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,

Re: Only one value can be selected from the listbox

jagan — Mon, 04 Jun 2012 10:44:38 GMT

Hi Siva,

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

Regards,

Jagan.

Re: Only one value can be selected from the listbox

IAMDV — Mon, 04 Jun 2012 11:15:14 GMT

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,

www.QlikShare.com

Only one value can be selected from the listbox

swuehl — Mon, 04 Jun 2012 12:03:08 GMT

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

Re: Only one value can be selected from the listbox

IAMDV — Mon, 04 Jun 2012 12:22:20 GMT

Hi Stefan,

Well spotted. You are right, I don't think if there is a way to control this by using expression. I have used this expression within data islands to replicate the UI functionality of "Always one selected" feature. And I have stored the selected values in the variable to use them within my data model. But I don't think it will be relevant solution in this case. Sorry guys, my mistake for misunderstanding.

Thanks again.

Cheers,

Re: Only one value can be selected from the listbox

omerfaruk — Fri, 27 Jun 2014 10:59:34 GMT

Hi Deepak,

I’ve implemented your solution in our project. However I have 4-5 sheets needs to be implemented the same function. I’ve created similar scripts for different sheets with different way.

The problem is, when I move from sheets those functions are implemented, activated sheets select actions do not work. When I move from other sheets it works. So, there must be script running problem. Activated sheet’s script may be running at the same time with the previous sheet’s deactivate script. That might be the reason for triggers do not operate as expected in such cases.

I'm not experienced in scripts in qlikview. But If we can delay the triggers somehow I think we can avoid this situation.

So What is your suggestion for implementing this solution for multiple sheets and multiple list boxes inside these sheets?

Re: Only one value can be selected from the listbox

rustyfishbones — Fri, 27 Jun 2014 11:35:54 GMT

Hi Deepak,

would AGGR(Year,Year) do the same thing?

Regards

Alan

Re: Only one value can be selected from the listbox

omerfaruk — Mon, 30 Jun 2014 09:21:53 GMT

Hi,

Actually instead of removing selections, I simply hide the fields that I don't want them to be visible to the user.

This document tells how to do it.

Thanks.

Re: Only one value can be selected from the listbox

Anonymous — Wed, 10 Sep 2014 05:14:51 GMT

Hi Jagan,

can you please tell me what condition you applied in this example

i am also facing the same problem can you please give me the reply very urgent.

Thanks,

krishna

Re: Only one value can be selected from the listbox

jagan — Wed, 10 Sep 2014 05:55:14 GMT

Hi Krishna,

I used Field Event Triggers in

Settings -> Document Properties -> Triggers -> Field Event Triggers -> On Select - Add Actions ->

Add -> Select -> Select in Field

Give Year as Field and Search string as

=If(GetSelectedCount(Year), Max(Year))

Hope this helps you.

Regards,

Jagan.

Re: Only one value can be selected from the listbox

Anonymous — Wed, 10 Sep 2014 06:51:44 GMT

thank you very much Jagan Its working.

Thanks,

krishna.

Re: Only one value can be selected from the listbox

Qrishna — Tue, 05 May 2015 22:11:15 GMT

I know its too late, but to the benefit of others:

Minakshi,

Select any value in the field list box -->GoTo Properties -->General --Check the box 'Always one Selected Values'.

Hope this helps.

Thanks

Krishna

Re: Only one value can be selected from the listbox

mohammadkhatimi — Wed, 06 May 2015 07:15:11 GMT

Select any value in the field list box -->GoTo Properties -->General --Check the box 'Always one Selected Values'.

Regards,

Mohammad

Re: Only one value can be selected from the listbox

Anonymous — Fri, 26 Jun 2015 19:50:52 GMT

thank you