Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
TestingForTestPurposes
Partner - Contributor II
Partner - Contributor II

Number formatting in tables

Hi all,

I have two tables with several dimensions as columns. In both tables I have the column 'date' but I have the problem that in one table I am able to change the number formatting to a date format but in the other tabel there is not such an option, there I only have the option to display the value as a text, link, or picture and exclude null values.

What Do i have to change to be able to change the number formatting in both tables?

Labels (4)
1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

Try this

Date(DateField, 'YYYY-MM-DD') as Date

 

View solution in original post

3 Replies
qv_testing
Specialist II
Specialist II

without post any screen shot or sample data, difficult to provide solution 

Date(num#(datefield), 'MM/DD/YYYY')

https://community.qlik.com/t5/Member-Articles/Dealing-with-date-formats-in-QlikView-and-QlikSense/ta...

Chanty4u
MVP
MVP

Try this

Date(DateField, 'YYYY-MM-DD') as Date

 

TestingForTestPurposes
Partner - Contributor II
Partner - Contributor II
Author

I am nut sure if the issue is actually related to the date format. I rather have the hypotheses that it has to do with the configuration of the table as I the options to change the format of the values within the table substantially differs (see attached pictures).