Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.