topic Re: date format changed in QlikView

date format changed

stekol61 — Tue, 22 Jan 2019 15:54:07 GMT

Hi!

I have a QlikView app with several graphs.
I'm using a variable (below) for the time dimension in all graphs
It is possible to switch between 'Day', 'Week' and 'Month'

For some reason the date format has changed from e.g '2019-01-20' to '43485' in all graphs.

'Week' and 'Month' format is OK.

Any suggestion?

=if(v_period='Day', 'Date',
if(v_period='YearWeek','YearWeek',
if(v_period='YEARMONTH', 'YEARMONTH')))

Re: date format changed

juraj_misina — Tue, 22 Jan 2019 16:40:48 GMT

I'd say that the format changed in source data. To make sure try format the Date field with Date() function in script and see if that helps.
Juraj

Re: date format changed

MindaugasBacius — Wed, 23 Jan 2019 07:11:57 GMT

Maybe the change in Document Properties > Number formatting may do the job. Have you tried it?