topic Re: Setting default number format in the script in QlikView

Setting default number format in the script

DavidFoster1 — Fri, 06 Sep 2013 15:50:24 GMT

Is it possible to set the default format for a date/number in the script instead of the document properties.

What I am trying to do is calculate the start of the month of a particular date and have that month start formatted as MMM-YY while still remaining as a date datatype (allows other formatting and implicit sorting).

I want to include this in a master calendar procedure so I would prefer to be able to script the formatting instead of manually amending it.

Thoughts?

Re: Setting default number format in the script

Fri, 06 Sep 2013 16:06:12 GMT

Hello David,

You can set the default format in script by:

SET DateFormat='MMM-YY';

Is this what are you looking for?

Re: Setting default number format in the script

DavidFoster1 — Fri, 06 Sep 2013 16:08:45 GMT

That is the universal option that applies to all dates in your model. I am looking for an option for individual fields.

Re: Setting default number format in the script

Clever_Anjos — Fri, 06 Sep 2013 16:14:01 GMT

There is a simple trick to do that

First you create a dummy table to format you field

Temp:

LOAD

date(Today(),'MMM/YYYY') AS _month

AutoGenerate 1;

then you load you real data

yourrealtable:

LOAD

rand() as field1,

rand() as field2,

monthstart(today() - RecNo()) as _month

AutoGenerate 100;

Then you can drop your dummy

Drop Table Temp;

QlikView seems to respect the format of first data loaded for a field