Empty Table :Inline vs Autogenrate(0)

[#1]

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.

[Miguel_Angel_Baeyens · Accepted solution]

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