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

Getting # symbol as display in output

How can I display actual output in qv dashboard. It displayes # symbol instead of values.

1 Solution

Accepted Solutions
Anonymous
Not applicable

This can happen when the data is too long to display.  Try making your column wider.

View solution in original post

5 Replies
Anonymous
Not applicable

This can happen when the data is too long to display.  Try making your column wider.

l_palacios
Contributor III
Contributor III
Author

Wow. I didn’t even think of doing that. Let me ask you this. The value is a date value that is getting populated. This is the output: 3/18/2013 0:00

How do I just display the date and exclude the 0:00?

Thank you so much for your help.

-Luch

Anonymous
Not applicable

in load script when creating the field use something like :

date ( floor ( [YourDate ] ) , 'M/DD/YYYY' )

l_palacios
Contributor III
Contributor III
Author

Hi Bill,

I forgot to say thank you. This helped but I found a way to do in the document properties of the dashboard.

Anonymous
Not applicable

The best way of saying thank you is to mark answers as correct/helpful

BTW, you can also define date format on the object level.

One important note: when you use floor(YourDateField) function, you make the field shorter by removing the time part, hence saving noticeable amount of application size.