Store everyday data into qvd qliksense

[Aspiring_Developer]

Hello All,

I have below data set :-

I wish to store the data everyday i.e a qvd of today's date should be created in the script itself.

How can I achieve it dynamically ?

Thanks in advance

[brunobertels]

Hi 

May be load all from the resident table V_EMS_OPEN_TRENDING with a where clause to filter on the max Date 

then store it into qvd using max date as a variable in the name of the qvd 

[Aspiring_Developer]

Hi ,

Thanks for your response.

I need to store qvd for every day and for last 7 days . 

Not sure if it can be achieved via Max date

[brunobertels]

Hi 

Of course you can 

the where clause should by Something like that 

Where date >= max(date,7)