Number formatting in tables

[TestingForTestPurposes]

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?

[qv_testing]

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 · Accepted solution]

Try this

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

[TestingForTestPurposes]

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).