topic Re: Store Variable value back in the QVD in QlikView

Store Variable value back in the QVD

Thu, 07 Jul 2016 10:30:08 GMT

Hi Guys,

I download some data from a weblink and it is a very small data but the value changes everyday.

I have the QVW application scheduled for reload every morning at 9 AM.

This application loads 1 table containing 2 fields likes this.

What I want to do is...

Sum the total price and store that value somewhere with date and use that date and value the next day to compare change in the total price over time.

What is the best way to achieve this?

boorgura — Thu, 07 Jul 2016 14:44:34 GMT

You can write a piece of code to store a QVD.

something like this:

TotalPrice:

LOAD Sum(Price) as TotalPrice,

date(today()) as Current_Date

from <weblink source> ;

store TotalPrice into <filepath>TotalPrice.qvd;

Anonymous — Thu, 07 Jul 2016 14:50:51 GMT

Yes i would agree with Rakesh. If you wanted to store the sample of those QVDs historically. See below script

TotalPrice:

LOAD Sum(Price) as TotalPrice,

date(today()) as Current_Date

from <weblink source> ;

store TotalPrice into <filepath>TotalPrice_today().qvd;