Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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
IAMDV
Luminary Alumni
Luminary Alumni

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,

DV

omerfaruk
Creator
Creator

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?

rustyfishbones
Master II
Master II

Hi Deepak,

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

Regards

Alan

omerfaruk
Creator
Creator

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.

Anonymous
Not applicable
Author

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

jagan
Luminary Alumni
Luminary Alumni

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.

Anonymous
Not applicable
Author

thank you very much Jagan Its working.

Thanks,

krishna.

Qrishna
Specialist III
Specialist III

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

mohammadkhatimi
Partner - Specialist
Partner - Specialist

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


Regards,

Mohammad

Anonymous
Not applicable
Author

thank you