Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Joseph_Kipling
Contributor III
Contributor III

Date not formatting as continuous chart

Hi, 

I am trying to use a YearMonth as a continuous line chart. I have got it working for one date but a different date doesn't work and brings up an integer format - see image attached. 

I have tried unticking the "Auto" button on the formatting section of the chart but nothing works - any ideas?

This doesn't format correctly even though its using the same type of date field.This doesn't format correctly even though its using the same type of date field.This formats correctly as continuous chart. The date field is a YearMonth date field.This formats correctly as continuous chart. The date field is a YearMonth date field.

Labels (6)
3 Replies
Antoine04
Partner - Creator III
Partner - Creator III

Hello,

I am actually facing the same issue. Did you find any solution ?

Regards,

sergio0592
Specialist III
Specialist III

Hi,

And what happened if you try as dimension with 

Date(SaleDate_YearMonth,'YYYYMM')
Antoine04
Partner - Creator III
Partner - Creator III

Hi Sergio,

Thanks for answering. Indeed, it works.

But I still can not understand why it was showing the date as numbert format on a continous axis.

First time it happened to me.. 😂

Thanks and regards