Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

zied_ahmed1
Contributor III

problem QVD

Hello,

I load data in QVD since today,

the problem is when i reload i will have the data of today and the data will duplicate and this is the code :

Table:  

  load

  Type ,

  taxe,

  car,

  car_two,

  AutoNumber(date(date, 'DD/MM/YYYY'),'%Date ID') as [%Date ID]

  FROM $(vQvdPath);

    Concatenate

  load AutoNumber(date(date, 'DD/MM/YYYY'),'%Date ID') as [%Date ID],

  date,

  Type_M ,

  Taxe,

  car,

  car_two Resident Flotte2 where "date"= Today() ;

   STORE

into $(vQvdPath);

3 Replies
tajmohamed30
Contributor III

Re: problem QVD

tried where not exist function, or save it as new QVD

migueldelval
Valued Contributor

Re: problem QVD

Hi Zied,

Why are you loadind fields from resident table?

I´m trying to understand better your process.

Regards

Miguel

amartinez35
Valued Contributor

Re: problem QVD

Hi,

Try :

Data:

Load

  date*1 as [%Date ID],

  Type_M,

  Taxe,

  car,

  car_two

Resident Flotte2 where "date"= Today()

;

 

Concatenate(Data)

Load

  Type_M ,

  Taxe,

  car,

  car_two,

  [%Date ID]

FROM $(vQvdPath)

Where not exist ([%Date ID], [%Date ID]);

store Data into $(vQvdPath);

Community Browser