topic Re: Macro or default selection in QlikView

Macro or default selection

Mon, 12 Oct 2015 09:03:55 GMT

Hi all,

When we apply macro to select say say two products A and B.

In the current selection it comes as (A|B). but i want it as A,B just like normal selection .

Also if i have a value like age . I apply macro for selection in age as (""2 years""|""4 years"")

It comes in current selections as ("2 years"|"4 years"). Is there a way to replace this bar in macro script by , and ger rid of these brackets, inverted comas etc?

Thanks

Khushboo

Re: Macro or default selection

petter — Mon, 12 Oct 2015 09:33:48 GMT

If you do a more elaborate VBScript coding you can get your comma:

Sub SelectMyValues
  Set f = ActiveDocument.Fields("Year")
  Set fv = f.GetNoValues  'empty array
  fv.Add
  fv.Add
  fv(0).Number = 2015
  fv(0).IsNumeric = true
  fv(1).Number = 2010
  fv(1).IsNumeric = true
  If Not( f.SelectValues(fv) ) Then
  ' do some error handling
  End If
End Sub

Re: Macro or default selection

Mon, 12 Oct 2015 09:47:54 GMT

if i have to test for string rather than numberic values?

Can you modify macro for string ?

Re: Macro or default selection

petter — Mon, 12 Oct 2015 09:59:13 GMT

You change

fv(0).Number = 2015 into fv(0).Text = "2015"

and

fv(0).IsNumeric = false

Re: Macro or default selection

Tue, 13 Oct 2015 07:49:29 GMT

Thanks Petter 🙂

Re: Macro or default selection

Tue, 13 Oct 2015 12:15:55 GMT

Petter,

If we have more than 2 values to select .

fv(2).Number = 2011

fv(3).Number = 2012

Like this?