topic Re: Getting # symbol as display in output in QlikView

Getting # symbol as display in output

l_palacios — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Getting # symbol as display in output

Anonymous — Tue, 12 May 2015 16:00:37 GMT

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

Re: Getting # symbol as display in output

l_palacios — Tue, 12 May 2015 16:06:38 GMT

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

Re: Getting # symbol as display in output

Anonymous — Tue, 12 May 2015 16:15:07 GMT

in load script when creating the field use something like :

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

Re: Getting # symbol as display in output

l_palacios — Thu, 14 May 2015 21:13:28 GMT

Hi Bill,

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

Re: Getting # symbol as display in output

Anonymous — Thu, 14 May 2015 21:37:42 GMT

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.