Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to store transaction data(table contains 3 years data) which is stored in a qlikview table in to Monthly QVD and MonthEnd QVD. Each Monthly QVD should contain entire month QVD(eg: 1st Jan to 31st Jan or 1st Jan to 20th Jan(If the data contains only till 20th Jan)). Each MonthEnd qvd should contain data for End of the month(eg: Jan MonthEnd QVD should contain data only for 31st Jan or it should contain 20th Jan if(If the data contains only till 20th Jan).While storing the qvd(Both Monthly and MonthEnd QVD) it should be prefixed with table name and suffixed with month and Year. We store it in seperate folder to differentiate the same.
Could you please help me out to store the QVD's as described above. It is little urgent!
Thanks,
Attitude
Hi Sushil,
Thanks for your help! I am yet to check your code. I want to store both Monthly and MonthEnd qvd's in below format but in different folder(To differentiate montly and monthend qvd).Could you please do the required change in the script.
QVDNAME.2012_01.QVD Format: QVDNAME.YYYY_MM.QVD
Thanks,
Attitude
Hi Sushil,
Are you there? Can you please reply back as soon as you can as it is little urgent
Thanks,
Attitude
Thanks Nirmal I will refer and update
Is this working.
Please give me sometime. I am currently trying what sushil has given to me. It is something I was looking for. I will try yours later and will update you.
Hello if you want to store the qvd's in specific folder then change the code as
Initially set a variable for the desired folder path
SET vcQvdPath = I:\Qlikview\Qvds\
then change in the code
STORE [$(monthname)_END] into $(vcQvdPath )T_$(monthname)_END.qvd(qvd);
HTH
Sushil
I wanted something like below! It was posted earlier!
Hi Sushil,
Thanks for your help! I am yet to check your code. I want to store both Monthly and MonthEnd qvd's in below format but in different folder(To differentiate montly and monthend qvd).Could you please do the required change in the script.
QVDNAME.2012_01.QVD Format: QVDNAME.YYYY_MM.QVD
Thanks,
Attitude
Hi,
i have changed the code,
make sure your folder path should me correct.
Please let me know i you have any concern..
and if your problem is resolved then mark this as right answere and close the thread.
HTH
Sushil