topic Re: Reg:Dynamically update file name in QlikView

Reg:Dynamically update file name

Mon, 21 May 2012 17:10:34 GMT

Hi all,

I am having following scenario.ln that every month .qvw file name has to change automattically/dynamically.

Ex:

if current month file name is ABC_05_2012 (May month). when next month (june) comes fle automattically should get changed like ie;ABC_06_2012.

kindly let me know if any of you have thughts on this.

-Jai

oscar_ortiz — Mon, 21 May 2012 18:01:08 GMT

You can use variables to make the load more dynamic.

LET vMonth = Num(Month(Today()),'00');

LET vYear = Year(Today());

Then in your load statement:

LOAD

FROM

ABC_$(vMonth)_$(vYear)

;

Good luck

Oscar