Default Selection in Qlikview

[mhmmd_srf]

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

[avinashelite]

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

[Anonymous]

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

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

[jonathandienst]

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.

[mhmmd_srf]

Hi Avinash,

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

Thanks,

Sarif

[avinashelite]

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

[SNR1]

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