Save Partial Information in a QVD

[#1]

Hi everyone ;

It is posible to save the information from oracle table in a QVD for this way:

im my table save the infromation moth by moth but every month delete the historical information just i have the month actual in my table

what is mean is that:

if have the information from July i need this:

Vta:

Load

AnioMes,

Cliente

resident Ventas;

Store Vta into ..\Vta_072017.qvd

After the next moth all information from July it is delete in now i have Agust

Vta:

Load

AnioMes,

Cliente

resident Ventas;

Store Vta into ..\Vta_082017.qvd

I need differents QVD's by month

Thanks

[ankur_abhishek]

Hi Omar, Yes this can be possible & it can be easily achievable in qlik.

Us need to add where condition in date column to fetch the current month data.

Let vDate= Month(Today());

Vta:

Load

AnioMes,

Cliente

resident Ventas

where date= Month(Today());

Store Vta into ..\Vta_$(vDate).qvd;

this will store different qvd by month.

[arvind_patil]

Hi Omar,

Try to store  as below:

let vMindate = Date(monthstart(today()),'DD-MMM-YYY');

Vta:

Load

AnioMes,

Cliente

resident Ventas;

Store Vta into ..\Vta_072017.qvd where Date >=$(vMindate) (qvd);

Store Vta into <Path>.qvd(qvd);

Thanks,

Arvind Patil