Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Chart label

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

Tags (1)
4 Replies

Re: Chart label

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.

Not applicable

Re: Chart label

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

thanks

Re: Chart label

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

Re: Chart label

Hi,

Try this in script,

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

Use this field as a Dimension In Your Chart.

Regards,