topic Re: What parameter sets a field's automatic presentation format in a table? in QlikView

What parameter sets a field's automatic presentation format in a table?

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

I set up a script with a Today() function and the table displays automatically the Date format (image 1), what parameter controls this?

I tried searching on the Settings -> Document Properties in Number and Tables sheet to no avail (image 2 and 3).

Thanks in advance.

Re: What parameter sets a field's automatic presentation format in a table?

Anil_Babu_Samineni — Mon, 15 May 2017 17:27:41 GMT

You must aware of SysDate() in DB. The same functionality works as Qlik products. Here, the date format working as System date format of your Machine

Re: What parameter sets a field's automatic presentation format in a table?

Anonymous — Mon, 15 May 2017 17:28:39 GMT

if I use today() within a textbox, I get the following value (German date format)

So I suppose, that the return value of today() is (dual) date instead of num,

although it is displayed as num...

(QV11.2 SR15)

Re: What parameter sets a field's automatic presentation format in a table?

trdandamudi — Mon, 15 May 2017 17:28:46 GMT

It takes it from the script main tab:

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';

Hope this helps...

Re: What parameter sets a field's automatic presentation format in a table?

julioarriaga — Mon, 15 May 2017 17:45:04 GMT

Thanks, but my question is, what parameter is asigning it as a date? Not where it obtains the type of date format.

Re: What parameter sets a field's automatic presentation format in a table?

Anonymous — Mon, 15 May 2017 17:47:58 GMT

as I wrote below, in my opinion it makes no sense as you see at my textbox example...

Re: What parameter sets a field's automatic presentation format in a table?

julioarriaga — Mon, 15 May 2017 17:49:09 GMT

But where is the tag that presents it as a date? The dual presents it as numeric and integer.

Or where is the presentation/number parameter that puts it as a date?

Re: What parameter sets a field's automatic presentation format in a table?

swuehl — Mon, 15 May 2017 18:44:28 GMT

Have you tried to increase the width of the column in the Fields properties?

Seems like there are more tags to come...

Re: What parameter sets a field's automatic presentation format in a table?

Anonymous — Mon, 15 May 2017 18:46:29 GMT

you're right

load today() as test AutoGenerate 1;

But why is it $date, if the return value is num ?!?

Re: What parameter sets a field's automatic presentation format in a table?

swuehl — Mon, 15 May 2017 19:54:02 GMT

Maybe because the return value is in fact a dual?

today ‒ QlikView

Don't take the auto completion and even the HELP for 100% correct...

Re: What parameter sets a field's automatic presentation format in a table?

Anonymous — Mon, 15 May 2017 19:57:36 GMT