Global changes to 'Hide Excluded'

Wed, 21 Aug 2013 05:37:11 GMT

My users are split exactly 50/50: half want to see the excluded selections in list boxes, and half prefer the greyed-out view with no text for selected items.

Is there a way of changing this option globally for the whole model, or do we have to iterate through all the list boxes? I can't see this as a global setting in the Document Properties.

As a general question, where is this sort of thing documented? There's some in the Tech Ref but it's quite limited.

Thanks,

Prune.

Re: Global changes to 'Hide Excluded'

marcus_sommer — Wed, 21 Aug 2013 13:06:26 GMT

You could set these user-depending - if(osuser() = ... - per macro triggered by any event. See APIGuide.qvw for examples like this:

set LB = ActiveDocument.GetSheetObject("LB01")

set box=LB.GetProperties

box.Layout.ExcludedValuesMode = 1

box.Layout.HideExcluded = true

LB.SetProperties box

- Marcus

topic Re: Global changes to 'Hide Excluded' in QlikView

Global changes to 'Hide Excluded'

Re: Global changes to 'Hide Excluded'