Empty Table :Inline vs Autogenrate(0)

Wed, 05 Sep 2012 08:22:18 GMT

Hi,

I would like if someone can explain this strange behaviour with Autogenerate(0).

Thanks in advance

Calendar:

NoConcatenate

Load

Date(MakeDate(2012)+RecNo()) as Date_Calendar

AutoGenerate(100);

Store Calendar into Calendar.QVD(qvd);

Drop Table Calendar;

//-- Table Inline

Calendar_1:

NoConcatenate

Load * Inline

[Date_Calendar_1];

Concatenate(Calendar_1)

Load

Date_Calendar as Date_Calendar_1

From

Calendar.QVD

(qvd);

//-- Table Autogenrate ($text tag)

Calendar_2:

NoConcatenate

Load

Null() as Date_Calendar_2

AutoGenerate(0);

Concatenate(Calendar_2)

Load

Date_Calendar as Date_Calendar_2

From

Calendar.QVD

(qvd);

//-- Table Autogenrate ($ascii tag)

Calendar_3:

NoConcatenate

Load

1 as Date_Calendar_3

AutoGenerate(0);

Concatenate(Calendar_3)

Load

Date_Calendar as Date_Calendar_3

From

Calendar.QVD

(qvd);

//--

Obtain 3 Tables:

Calendar_1 = Calendar_3

Calendar_2 in field Date_Calendar_2 qlik don't recognize Date Type.

Re: Empty Table :Inline vs Autogenrate(0)

Miguel_Angel_Baeyens — Wed, 05 Sep 2012 08:54:40 GMT

Hi,

QlikView does recognize the field as a date, if you hover the mouse on the field the $date tag is there. Date values in QlikView are actually numeric, although they can be represented as a literal "12/01/2012" or as a numeric value 40920.

So why is not QlikView representing the field Date_Calendar_2 as a literal date? INLINE empty values are not actual nulls, but empty, while Null() function does return an actual null value.

You will find extremely useful this blog post by Henric Cronström The Importance of Nothing and its related documentation on how QlikView handles NULL values.

Hope that helps.

Miguel

topic Re: Empty Table :Inline vs Autogenrate(0) in QlikView

Empty Table :Inline vs Autogenrate(0)

Re: Empty Table :Inline vs Autogenrate(0)