topic SV:Re: Multi box select / highlight entry if only one available in QlikView

Multi box select / highlight entry if only one available

Tue, 09 Mar 2010 11:44:17 GMT

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?

Multi box select / highlight entry if only one available

Miguel_Angel_Baeyens — Tue, 09 Mar 2010 12:02:48 GMT

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.

SV:Re: Multi box select / highlight entry if only one available

Wed, 10 Mar 2010 13:43:53 GMT

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