Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
Greetings for the Day!!
I have a requirement like ;
I need to generate daily wise qvd's for Jan-2016 to Dec-2016.
Kindly help me how to create these daily qvd's.
Thanks & Regards,
Anjaneyulu
Hi Anjaneyulu,
just follow this below post..!!it will help you.
Creating Daywise QVDs | Qlik Community
--surendra
We need to understand your requirements first.
How you want to create daywise qvds? Are you going to create from Database table or you already have a big QVD and you want to generate daywise qvds from this big QVD?
There are few steps you need to perform.
1) First time, you need to create day wise qvds for each date using for loop.
2) For Next time onward, Consider that we have stored QVDs as Data_20161231 (i.e. Data_YYYYMMDD).. we need to find out which one is the last date of QVD stored. This can be done using For Each file loop.
3) Find out new data which are > max date and create QVD for it.
So better to provide us right information to help you further.
Happy Qliking.
Regards,
MK
Hi Manish,
I have Production table Like;
Production:
Load
A,
B,
C,
Data_of_Prodution,
E,
Z
From
[lib://QVD/tbl_TUProduction.qvd]
(qvd) where date(Date_Of_Production,'DD/MM/YYYY')='01/01/2016';
And also i have Final qvd Generating table like;
ProdDaywise:
Load
a,
b,
c,
Date_Of Production,
E
Resident Production
Drop Table Production;
Store ProdDaywise into [lib://QVD\DailyProdQVDs\ProdDaywise_01-Jan-2016.qvd];
Here i am changing the date manually from 01/01/2016 to 31/01/2016 by each time and generating the qvd.
so i need to get any automation to create 30 days qvd's automatically.
Is there any way?
Regards,
Anjaneyulu
create a variable let d=date(today(), 'YYYYMMDD');
Production:
Load
A,
B,
C,
Data_of_Prodution,
E,
Z
From
[lib://QVD/tbl_TUProduction.qvd]
(qvd) where date(Date_Of_Production,'DD/MM/YYYY')='01/01/2016';
And also i have Final qvd Generating table like;
ProdDaywise:
Load
a,
b,
c,
Date_Of Production,
E
Resident Production
Drop Table Production;
Store ProdDaywise into [lib://QVD\DailyProdQVDs\ProdDaywise_$(d).qvd] (qvd);