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: 
LauraMorris
Contributor III
Contributor III

Format column total in table as number not date

I have a straight table in my dashboard with a list of dates. Not every row has a date, some are null so I want the total of this column to be the count of dates. If I select count as the total function it does count them correctly but it is formatting it as a date.  How do I format this as a number? 

 

I've checked the dimensionailty of the header is 0 and have tried the following in the custom format pattern of the column in question but it just writes the words rather than formatting it:

=IF(Dimensionality()=0,'#,##0','DD/MM/YYYY')

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan

Hi 

use the format in the expression and change the number formatting as "Measure expression"

Try like below

=if(dimensionality() = 0, num(urexp, '#,##0'), date(urexp, 'DD/MM/YYYY'))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

Hi 

use the format in the expression and change the number formatting as "Measure expression"

Try like below

=if(dimensionality() = 0, num(urexp, '#,##0'), date(urexp, 'DD/MM/YYYY'))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
LauraMorris
Contributor III
Contributor III
Author

That's brilliant, thank you so much for your help.