Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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