Discussion board where members can get started with Qlik Sense.
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
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.
where do I enter this formatting? In the query used in the data load editor or somewhere else?
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.
Try this in script,
Date(floor(datefield),'DD-MM-YYYY') as Date_Field
Use this field as a Dimension In Your Chart.