topic Re: Store everyday data into qvd qliksense in App Development

Store everyday data into qvd qliksense

Aspiring_Developer — Tue, 24 May 2022 08:28:52 GMT

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 — Tue, 24 May 2022 09:54:27 GMT

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 — Tue, 24 May 2022 10:19:54 GMT

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 — Tue, 24 May 2022 12:32:07 GMT

Of course you can

the where clause should by Something like that

Where date >= max(date,7)