topic Re: Selected multiples values using macro in QlikView

Selected multiples values using macro

thierrytt1102 — Fri, 20 May 2016 09:39:53 GMT

Dear,

I'd like to select 2 years using a macro.

This works for only 1 year :

ActiveDocument.GetField("Year").Select "2015"

How can I do for 2 values?

ActiveDocument.GetField("Year").Select "2015", "2016" -> doesn't work

Thank you for your help

MindaugasBacius — Fri, 20 May 2016 09:46:25 GMT

thierrytt1102 — Fri, 20 May 2016 09:49:09 GMT

Thanks but it's not exactly what I want, I'd like to have the possibility to select text values and not only numbers as "Year"

Kushal_Chawda — Fri, 20 May 2016 09:51:57 GMT

Why you are using macro? Can you tell us exactly what you want to do? I think it is possible by triggers.

See this

tamilarasu — Fri, 20 May 2016 09:52:15 GMT

Hi Thierrytt,

Try,

ActiveDocument.Fields("Year").Select ("(2015|2016)")

thierrytt1102 — Fri, 20 May 2016 09:56:30 GMT

because it's part a pdf printing module using macro