Chart label

[#1]

I am new to Qlik Sense. How can I remove the time stamp from a chart label and just display the date. In the query in the data load editor I

truncated the date field but it did not change the label on the chart

thanks

[Anonymous]

Maybe something like

Date( trunc ( YourDate ) , 'DD MMM YYYY'  )

The 'DD MMM YYYY'  defines its text display format, you may wish to use different display format.

[#3]

where do I enter this formatting? In the query used in the data load editor or somewhere else?

thanks

[Anonymous]

You mentioned earlier "in the data load editor truncated the date field", so I was thinking of using this to format the truncated value in the load script.

[pathiqvd]

Hi,

Try this in script,

Date(floor(datefield),'DD-MM-YYYY') as Date_Field

Use this field as a Dimension In Your Chart.

Regards,