Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to accumulate website-data in a .qvw

Hey,

I still use a demo version and can call myself proud a "real beginner".

I managed to read the german stockmarket-index DAX from the website of the "Deutsche Börse", with the coresponding time/date in a field.

Each time I run the script (as attached), I "overwrite" the value.

How can I "accumulate"/ ass the values to the qvw each time I run the script and the date-time-field changes?

Is it possible to run the script every minute or though?

best wishes,

S., happy with his first step, hoping to do the second now 🙂

--

SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';
SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';


TabelleDax:
LOAD [Letzter Stand],
[Datum, Zeit]
FROM
[http://deutsche-boerse.com/bf4dbag/DE/export/export.aspx?module=priceinfo&isin=DE0008469008&navpath=http://deutsche-boerse.com/dbag/dispatch/de/isg/gdb_navigation/home]
(html, codepage is 1252, embedded labels, table is @1, filters(
Transpose()
));

3 Replies
mmichalke
Partner - Contributor III
Partner - Contributor III

Hey Sebastian,

where did you find something regarding the syntax and how to include data from a website. are there any prequesites regarding the website ?

Hope to get some response from you soon !

Not applicable
Author

Hey,

I used the "Assistant".

edit script - "Data/Web Data" - ...selfexplaining

Greets

S.

Not applicable
Author

Sebastian,

Search the forums (and the QlikView Reference Manual that came with your installation) for "Incremental Load"...this will discuss how to store and update information at regular intervals.