topic Re: Default Selection in Qlikview in QlikView

Default Selection in Qlikview

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

Hi All,

I have a requirement to make default selection as Product Code = 070 and 006.

I have implemented using Triggers in Document Properties. It is working. It is looking like this:

However user wants to see these as selected with Green shade.

How to implemented this.

Please help.

Thanks,

Sarif

Re: Default Selection in Qlikview

avinashelite — Wed, 29 Mar 2017 07:45:50 GMT

Your list box is a built on the expression ?? if that is the case then it will not highlight in green

then you need create the Combined filed in the script and in trigger need use like (006) - * and (070) - *

Hope this helps you

Re: Default Selection in Qlikview

Anonymous — Wed, 29 Mar 2017 07:46:24 GMT

If you want it when document is opened, try adding trigger select in field <field name>

value as defaultvalue1 &'|'& defaultvalue2. on open.

Re: Default Selection in Qlikview

jonathandienst — Wed, 29 Mar 2017 08:11:43 GMT

It will only display in green if the selection is made on the field in the listbox. If your trigger is making a selection in another field, it will be white in the list box. Make the trigger selection to act directly on the field in the listbox.

If the listbox contains a calculated expression, then the trigger can only make selections on the underlying fields, so the listbox will not get green highlighting and you cannot make a selection via an action that will be indicated in green.

The only solution in this case is to add the expression as a derived field in the load script, then you can have the trigger select the new derived field and it will be highlighted in green.

Re: Default Selection in Qlikview

mhmmd_srf — Wed, 29 Mar 2017 08:12:08 GMT

Hi Avinash,

If we select those two value in the doc and save .qvw file. Will it work?

Thanks,

Sarif

Re: Default Selection in Qlikview

avinashelite — Wed, 29 Mar 2017 08:22:57 GMT

Yes , and the trigger needs to be set on the new combined field

Re: Default Selection in Qlikview

SNR1 — Fri, 22 Jun 2018 12:51:11 GMT

Hi Avinash , I tried above scenario but im getting same error i have 4 fields like 6/15 4/23 3/23 5/23 and 6/15 need to selected but 5/23 is selecting same expression i used in text box it shows 6/15 value please suggest me asap =IF(Source2MonthVersionLabel<>'Sales Plan',Maxstring(MonthVersionLabel)) Thanks InAdvance