topic Re: Add the frequency in every listbox by script in QlikView

Add the frequency in every listbox by script

fredericvillemi — Mon, 01 Aug 2011 20:21:12 GMT

Hi,

i'm trying to use some vbscript in Qlikview and i feel the model is quite difficult.

What i would like to do :

i want to open a document, list all the listboxes only and add the "Frequency in percent" to all of them.

I can't even find how to have an easy list of all listboxes in the document..

can you help me ?

Thanks

Re: Add the frequency in every listbox by script

danielrozental — Mon, 01 Aug 2011 20:44:08 GMT

Try something like this

sub abc()
    for j= 0 to ActiveDocument.NoOfSheets - 1
        set s=ActiveDocument.Sheets(j)
        lboxes=s.GetListBoxes
        for i=lbound(lboxes) to ubound(lboxes)
             set box=lboxes(i).GetProperties
             box.Layout.ShowFrequency = true
             box.Layout.FrequencyInPercent = true
             lboxes(i).SetProperties box
        next
    next
end sub

Re: Add the frequency in every listbox by script

fredericvillemi — Mon, 01 Aug 2011 21:30:58 GMT

that's excellent ! Thanks, very nice example.

And just one more thing : if i wanted to add expressions to my listbox, what is the syntax ?

addExpression doesn't seem to work with listboxes .. and properties.expressions.add seems not good ...

thanks

Re: Add the frequency in every listbox by script

danielrozental — Tue, 02 Aug 2011 00:56:08 GMT

It was a hard one, took me a bit

    Set lst = b.GetSheetObject("LB03")
    Set c = lst.GetProperties.Expressions
    c.Add
    Set x = c.Item(c.Count - 1)
    x.Data.ExpressionData.Definition.v = "sum(SalesAmount*2)"

Re: Add the frequency in every listbox by script

fredericvillemi — Tue, 02 Aug 2011 19:44:56 GMT

great !

scripting is sometimes quite tricky but so powerful !

thanks Daniel