script from qvw

mama25macs — Wed, 25 Nov 2020 16:16:04 GMT

can someone open this attached qvw, copy and paste the load script into a reply here? We have qliksense cloud, and only macs, so no access to qlikview... and the answer to a an article that solves an issue we have is in that qvw.

Thank you!

Re: script from qvw

Oleg_Troyansky — Tue, 20 Oct 2020 21:37:23 GMT

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

LOAD @1,
@2,
@3
FROM
[http://qvtest:qvtest@www.rpostma.com/qvtest/qvtest.csv]
(txt, codepage is 1252, no labels, delimiter is ';', msq);

topic script from qvw in QlikView

script from qvw

Re: script from qvw