topic Load 1 row into QVD every day in QlikView

Load 1 row into QVD every day

Fri, 28 Dec 2012 13:28:57 GMT

Here's what I have to do. I made a QVW that has some data about the number of reports we have. I have managed to send todays date and that report count to a QVD but how do I go about inserting a new row into the QVD every time it is reloaded as long as the date doesn't already exist in the qvd?

My current code for the QVD is this..

ReportCount:

LOAD

date(today()) as TotalCount_Date,

count(distinct((Report.Name))) as Report.Total.Count

Resident Reports;

store ReportCount into ...

Thanks!

Re: Load 1 row into QVD every day

montero91 — Fri, 28 Dec 2012 17:42:17 GMT

hi ethan

try it with variables:

Let Var_today= Today();

Let Nametable= ‘LOAD’ & $( Var_today);

$( Nametable):

LOAD

$( Var_today) as Date_Today

Resident Reports;

Let Var_Store = $( Nametable) & ‘.qvd’ ;

store $( Nametable) into $(Var_Store);

With this you must generate a qvd per day with a date field.

Then you make a query to load with 'LOAD *' to read all

I hope you find it useful.