Qlikview file on new (licenced) computer

Anonymous — Thu, 21 Dec 2017 12:37:28 GMT

Hi guys,

I have made a Qlikview file on a computer and putted the Qlikview file on another licenced computer. On this laptop, the Qlikview application doesn't work properly, because all the date/time formats are interpreted different. The code is the same, the input data is the same, my question is, how can we fix this? Is het something in the settings?

This is the used code (with dynamic input name, which was the same in the case above):

LOAD *, date([Effective date], 'DD-MM-YYYY'), mid(date([Effective date], 'DD-MM-YYYY'), 4,2) as [Maand], Date(Num([Effective date]+$(InputBetaalTermijn))) AS NumericDate

FROM $(InputBestandsNaam)

(ooxml, embedded labels, table is Sheet1);

Thanks for the help!!

Re: Qlikview file on new (licenced) computer

marcus_sommer — Mon, 08 Jan 2018 14:32:50 GMT

The variables at the very first beginning in the script define how dates and times are interpreted. Another important part of the recognition are the regional-settings from the OS. Maybe here are some differences between the machines / user-profiles.

- Marcus

topic Re: Qlikview file on new (licenced) computer in QlikView

Qlikview file on new (licenced) computer

Re: Qlikview file on new (licenced) computer