Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor II

Qlik sense data format

Hi guys,

What are the differences between date formatting functions like Date(), Date#(), Timestamp(), Floor(), etc.? What should the input and output date formats be?

Thanks for help! 

1 Solution

Accepted Solutions
thiago_justen
Valued Contributor III

Re: Qlik sense data format

Let's try to make it easier:

functions followed by hashtag are functions of interpretation. For example: date # is a function that interprets a text as a date field.


But it's better than my explanation if you could read this:


https://help.qlik.com/pt-BR/sense/November2017/Subsystems/Hub/Content/Scripting/InterpretationFuncti...


A good way to learn about it is read and read Qlik Help.


Here it is a good documentation about Qlik's functions - https://help.qlik.com/en-US/sense/1.1/pdf/Script%20Syntax%20and%20Chart%20Functions%20Guide.pdf



Cheers

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
1 Reply
thiago_justen
Valued Contributor III

Re: Qlik sense data format

Let's try to make it easier:

functions followed by hashtag are functions of interpretation. For example: date # is a function that interprets a text as a date field.


But it's better than my explanation if you could read this:


https://help.qlik.com/pt-BR/sense/November2017/Subsystems/Hub/Content/Scripting/InterpretationFuncti...


A good way to learn about it is read and read Qlik Help.


Here it is a good documentation about Qlik's functions - https://help.qlik.com/en-US/sense/1.1/pdf/Script%20Syntax%20and%20Chart%20Functions%20Guide.pdf



Cheers

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago