topic Re: Automating a QVD fle in QlikView

Automating a QVD fle

Wed, 10 Jul 2013 16:46:24 GMT

Hi,

I have a query which I run and it creates a QVD file.

In the opening statement I have

OLEDB Connect TO ........

Test_date:

Query Statement 1

-----------------------

STORE Test_date into Test_date.qvd

Drop table Test_date;

Here I would like to know if there is anyway I can rename the date from Test_date to a actual date.

As I want to run this every day and want the date change with todays date.

Thanks-

luciancotea — Wed, 10 Jul 2013 16:53:42 GMT

SET vName = date(Today(), 'YYYYMMDD');

OLEDB Connect TO ........

Test_date:

Query Statement 1

-----------------------

STORE Test_date into $(vName).qvd

Drop table Test_date;

Wed, 10 Jul 2013 17:24:38 GMT

how to make monthly report replacing jan by M1.....DEC BY M12

I HAVE COME TO THIS POINT IN MY SCRIPT

OrderID,

CustomerID,

EmployeeID,

OrderDate,

Year(OrderDate) as Year,

Month(OrderDate) as Month,

'Q' & Ceil(Month(OrderDate)/3) as Quarter,

Dual('Q' & Ceil(Month(OrderDate)/3) & '-' & Year(OrderDate),

Year(OrderDate) & Ceil(Month(OrderDate)/3)) as QtrYear,