Solved: Store Variable value back in the QVD - Qlik Community

Report Inappropriate Content · ‎2016-07-07

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 · ‎2016-07-07

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;

boorgura · ‎2016-07-07

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 · ‎2016-07-07

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;