Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multi box select / highlight entry if only one available

Since you are the fastest answering community around I throws this at you as it's urgent. [:)]

I have an application where we make data reduction when publishing on the server. Each reduced application then have one or several selections in 3 different fields available in a multi box. My problem is that I need to have a selection made on application load when there is only one value available in a field. White has to become green!

Any suggestions on this?

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hello,

It depends on which version of QV are you using, but in version 9 you can select "Actions" for a sheet (let's say some pre-programmed macros) that will do for you. Check sheet properties, go to Actions, On Activate, Action Type "Select", "Select in a field" and in the expression boxes enter the expressions for field and possible values that has to be selected.

Regards.

View solution in original post

2 Replies
Miguel_Angel_Baeyens

Hello,

It depends on which version of QV are you using, but in version 9 you can select "Actions" for a sheet (let's say some pre-programmed macros) that will do for you. Check sheet properties, go to Actions, On Activate, Action Type "Select", "Select in a field" and in the expression boxes enter the expressions for field and possible values that has to be selected.

Regards.

Not applicable
Author

Thank you for your suggestion.

We use 8.5 and I solved it with a macro.

set FldComp = ActiveDocument.Fields("Company_Name").GetSelectedValues

set FldComp_p = ActiveDocument.Fields("Company_Name").GetPossibleValues

if FldComp.count = 0 and FldComp_p.count = 1 then

ActiveDocument.Fields("Company_Name").Select "*"

end if