topic Re: Select combo box in QlikView

Select combo box

danosoft — Thu, 26 Sep 2019 16:33:16 GMT

Very simple question: In a select box (dropdown list) can i choose the first element for default?

Re: Select combo box

marcus_sommer — Fri, 27 Sep 2019 11:13:44 GMT

Probably yes, with something like:

match(Field, subfield(concat(distinct Field, ',', SortParameter), ',',1))

- Marcus

Re: Select combo box

danosoft — Fri, 27 Sep 2019 15:34:39 GMT

my databse field name is:DES_REFERENTE, so my expressio will be:

match(DES_REFERENTE, subfield(concat(distinct DES_REFERENTE, ',', SortParameter), ',',1))

Right?

what i need to put in SortParameter?

Re: Select combo box

marcus_sommer — Mon, 30 Sep 2019 07:04:29 GMT

The SortParameter is optional - if you leave it it will be automatically sorted in a alpha-numeric order. If this fits to your requirement you didn't need do more. But if not you may apply any numeric field as a sorting which might need to create in the script if you need any special ordering.

- Marcus

Re: Select combo box

danosoft — Mon, 30 Sep 2019 08:26:32 GMT

Ok, but if i write:

match(DES_REFERENTE, subfield(concat(distinct DES_REFERENTE, ',', ''), ',',1))

it not work, the dropdown list is blank

Re: Select combo box

marcus_sommer — Mon, 30 Sep 2019 09:01:50 GMT

Optional parameter which aren't needed must be left out and not specified as empty string or NULL or similar. Therefore try:

match(DES_REFERENTE, subfield(concat(distinct DES_REFERENTE, ','), ',',1))

- Marcus

Re: Select combo box

danosoft — Mon, 30 Sep 2019 09:25:05 GMT

not work sorry, it is blank without values with this expression

Re: Select combo box

marcus_sommer — Mon, 30 Sep 2019 09:41:59 GMT

Did you try to apply the expression within the listbox / combo box? That's the wrong place - at least like I understood your question which was that a certain value should be selected and not that this box contained just those single value.

If I understood it right this expression must be placed within an OnOpen action to select this value. Before this put this expression in a textbox to ensure that it returned your expected value.

- Marcus

Re: Select combo box

danosoft — Mon, 30 Sep 2019 09:55:26 GMT

ah i understand now, yes i had insert in a list box, so i will try to put in action in the sheet

Re: Select combo box

danosoft — Mon, 30 Sep 2019 10:05:42 GMT

ok i tried, but it not work sorry.

my listbox have the field: des_referente

i put in action of my sheet:

- select field: DES_REFERENTE

search string: match(DES_REFERENTE, subfield(concat(distinct DES_REFERENTE, ','), ',',1))

Re: Select combo box

marcus_sommer — Mon, 30 Sep 2019 11:19:53 GMT

Is this field "des_referente" or "DES_REFERENTE"? For QlikView it's not the same. Further did you this expression within a textbox and returned it the expected values? Also you need to ensure that the search-string is interpreted as expression and not only as a string, means adding:

= match(DES_REFERENTE, subfield(concat(distinct DES_REFERENTE, ','), ',',1))
or
= '=match(DES_REFERENTE, subfield(concat(distinct DES_REFERENTE, ','), ',',1))'

- Marcus

Re: Select combo box

Brett_Bleess — Tue, 08 Oct 2019 12:16:31 GMT

Daniele, did Marcus' last post finally get things working? If so, please do not forget to circle pack and use the Accept as Solution button the post(s) that helped you get things working as expected. If you did something different, consider posting that and mark it using the button to let everyone know what you did. If you are still working upon things, leave an update for us.

Regards,
Brett

Re: Select combo box

danosoft — Tue, 08 Oct 2019 13:25:51 GMT

no sorry not work, my field name is DES_REFERENTE
if i put in action on my sheet the expression: = match(DES_REFERENTE, subfield(concat(distinct DES_REFERENTE, ','), ',',1)) it not selected me the first value.
if i put this expression in a textarea it show me 1

Re: Select combo box

Brett_Bleess — Tue, 08 Oct 2019 13:31:22 GMT

It will likely help a lot in this case if you can attach a QVW file, so folks can see the data model etc... If there are confidential field data, you can use Settings\Document Properties\Scrambling to scramble those field values...

Regards,
Brett

Re: Select combo box

danosoft — Tue, 15 Oct 2019 13:05:59 GMT

hi i put an example

Re: Select combo box

Brett_Bleess — Tue, 15 Oct 2019 14:21:41 GMT

Daniele, thanks for that, I am attaching what I did, unfortunately I am not sure of the why, but I added three text objects to your app and split up the expression you are using into its subcomponents to test, and the issue is with the 'match' piece, that is returning null, but I am going to see if someone else can explain that part, but I checked the Help, and it would seem to me you are missing something here:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/ConditionalFunctions/match.htm

Maybe you will be able to sort it out at this point, but perhaps @marcus_sommer may be able to have another look too.

Regards,
Brett

Re: Select combo box

marcus_sommer — Tue, 15 Oct 2019 14:54:31 GMT

Take a look on the attachment.

- Marcus

Re: Select combo box

danosoft — Tue, 15 Oct 2019 16:14:11 GMT

if you change Sheet, and go again in the sheet it not work

Re: Select combo box

marcus_sommer — Wed, 16 Oct 2019 08:12:58 GMT

Yes, I put the action only in the textbox-button to show that the selection-logic worked.

- Marcus

Re: Select combo box

danosoft — Wed, 16 Oct 2019 08:53:37 GMT

Sorry but i need in the select box as you know, and there it not work. I not need that in the text area