topic Re: Naming Qvd automatically in QlikView

Naming Qvd automatically

Tue, 12 Mar 2013 12:34:46 GMT

I am having the data which which comes out everything and i should name it according to the month wise

for example in the month of feb i will get jan data and it happens every month and i wanted to make qvd's for these monthly and store them

for this I am using

Let vPrevMonth =PICK((Month(Today())-1),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec');

store PastMonth into $(QVD)\vPrevMonth.qvd(qvd);

but it is not working

Gysbert_Wassenaar — Tue, 12 Mar 2013 12:41:52 GMT

Try dollar expanding your vPrevMonth variable too:

store PastMonth into $(QVD)\$(vPrevMonth).qvd(qvd);

Tue, 12 Mar 2013 17:06:37 GMT

I am getting the month but also i need year also to be shown as Jan 2013

Tue, 12 Mar 2013 17:47:31 GMT

try

vYear = year(Today());

store PastMonth into $(QVD)\$(vPrevMonth&vYear).qvd(qvd);

by Rebeca

Tue, 12 Mar 2013 18:13:16 GMT

i want it to show Jan_2013.qvd

can you guide me on this one