topic Re: Save Partial Information in a QVD in QlikView

Save Partial Information in a QVD

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Save Partial Information in a QVD

ankur_abhishek — Sun, 06 Aug 2017 04:16:31 GMT

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.

Re: Save Partial Information in a QVD

arvind_patil — Sun, 06 Aug 2017 05:45:20 GMT

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