topic First value to be always default selected in List box in QlikView

First value to be always default selected in List box

chinnu123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

My list box contains Name field. The first value in the list box should be default selected.

For example My list box contains Ajay,

Bharat

Chigumbura,

Dely

Feroz

Sandhya

So as per Sorting order(A->Z) Ajay to be always selected by default. But in Future if any new names are added for example Abhi is added Then Abhi need to be default selected.

Abhi

Ajay

Bharat

Chigumbura,

Dely

Feroz

Sandhya

Can any one please suggest how to achieve this scenario.

Thanks in Advance,

Thanks,

Chinnu.

Re: First value to be always default selected in List box

effinty2112 — Sat, 29 Jul 2017 09:16:27 GMT

Hi Chinnu,

You could create a trigger to run when the app is opened. The action would be:

Select in field : Name

Search String : =minstring({1}Name)

Good luck

Andrew

Re: First value to be always default selected in List box

chinnu123 — Sat, 29 Jul 2017 09:29:47 GMT

Hi Andrew,

Thanks for your quick reply,

But unfortunately it's not working!

Thanks,

Chinnu.

Re: First value to be always default selected in List box

effinty2112 — Sat, 29 Jul 2017 09:41:53 GMT

Hi Chinnu,

Did you do this:

Go to Document Properties.

Tab Triggers

In Document Event Triggers select OnOpen then click button Add Action(s)

In the Actions dialog click the Add button

Action Type: Selection

Action: Select in Field

Click OK

In Actions dialog

Field : Name

Search String : =minstring({1}Name) ,include the '='

Click OK

Remember to include the '=' sign in the search string.

Try it out with a button first to trigger the action if you like.

Cheers

Andrew

Re: First value to be always default selected in List box

chinnu123 — Sat, 29 Jul 2017 10:11:33 GMT

Hi Andrew,

I followed the above steps it get selected the first value in the list box but when I am adding any new name its not getting selected.

For example I am having name Anand in my list box as first value so by default it would be selected

But when I am added new name Abhi in my name field so as per sorting Abhi will be the first value compare to Anand

so Abhi should be selected by default.

Hope I was clear

Thanks,

Chinnu.

Re: First value to be always default selected in List box

effinty2112 — Sat, 29 Jul 2017 10:27:50 GMT

Hi chinnu,

The new example you gave, Abhi, was also the first in alphabetical order and I thought that was what you wanted. Ok. You'll need to come up with a field you can use in an expression you can sort Name by. I know nothing about your data so I don't think there's anything I can suggest.

Good luck

Andrew

Re: First value to be always default selected in List box

chinnu123 — Sat, 29 Jul 2017 11:19:04 GMT

Hi Andrew,

Its working fine now

Re: First value to be always default selected in List box

Anonymous — Sun, 30 Jul 2017 16:06:31 GMT

Hi Andrew,

How can we do this in Cloud?

Can you please help me by sharing a qvf file?