topic One Value Always Selected in QlikView

One Value Always Selected

markmccoid — Tue, 23 Jun 2009 01:40:23 GMT

I'm trying to set the One Value Always Selected property on a field via a macro using the following:

set fieldDesc = ActiveDocument.Fields("CP1_EndDate").GetDescription
fieldDesc.AlwaysOneSelected = TRUE

It is not working and I'm not sure why. The API Doc says this property is read/write.

Any Ideas?

Thanks,
Mark

One Value Always Selected

Anonymous — Tue, 23 Jun 2009 03:40:37 GMT

Mark,
Before applying this property, you must select one value. Any value, but only one. Here is how it may look like


sub
 Set fld = ActiveDocument.GetField("CP1_EndDate") fld.Select <a specific value here>
 Set prop = fld.GetProperties
 prop.OneAndOnlyOne=True
 fld.SetProperties prop
end sub