Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to create day wise qvd's?

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

Tags (1)
4 Replies
Highlighted
Specialist
Specialist

Re: how to create day wise qvd's?

Hi Anjaneyulu,

just follow this below post..!!it will help you.

Creating Daywise QVDs | Qlik Community

--surendra

Highlighted
MVP
MVP

Re: how to create day wise qvd's?

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

Highlighted
Not applicable

Re: how to create day wise qvd's?

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

Highlighted
Creator II
Creator II

Re: how to create day wise qvd's?

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);