topic Re: Variable in QlikView

Variable

smilingjohn — Mon, 09 Mar 2015 04:52:52 GMT

HI All,

I have two list boxes one is for Month and the other is for Year .

And i have straight table which iam importing to export by Macro.

I wanted to know how can we save the file path by selected year and month.

i need to create a variable for month and year then i want to bring this variable in the path of macro .

Can some one help me

Re: Variable

tresB — Mon, 09 Mar 2015 05:06:11 GMT

You can define variables like:

vYear=YearField

vMonth=MonthField

And then use them in your macro. If you need help there too, try to share your macro code here.

Re: Variable

smilingjohn — Mon, 09 Mar 2015 05:26:29 GMT

Thanks Trescco ,

i have already created the variable , i have already defined a path iam sending u the file ,

actaully when the file is being saved it has to give me which year and whivh month .

i hope u undertood .

Plz find the attachment

Re: Variable

jyothish8807 — Mon, 09 Mar 2015 05:32:17 GMT

Hi Roy,

Try to create a variable in macro itself instead of creating in qlikview and call this variable in your macro.

sub ( .... )

dim var1=XXXX

path: c://New Folder/var1

Hope it help.

Regards

Re: Variable

tresB — Mon, 09 Mar 2015 05:36:57 GMT

Try something like:

filepath="D:\EXCEL TO EXPORT\"
Set yearVar=ActiveDocument.GetVariable("vYear")
Set monthVar=ActiveDocument.GetVariable("vMonth")
Set filename=yearVar&monthVar
....
XLDoc.SaveAs filePath & filename

Re: Variable

smilingjohn — Mon, 09 Mar 2015 05:37:12 GMT

HI Jyothish

Iam not understanding how to do it

I have already attached the macro code . Which will export different excel files by country by branch and by city

where do i define the variable ?