Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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()
));
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 !
Hey,
I used the "Assistant".
edit script - "Data/Web Data" - ...selfexplaining
Greets
S.
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.