Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
morenoju
Partner
Partner

How can I get rid of the date 12/30/1899 displayed on a line chart with continuous scale

Hi folks,

I have a line chart with the following dimension: =time(link_time_15min,'hh:mm')

Why does the line chart in Qlik Sense Desktop April 2020 shows the date 12/30/1899 below it? I know it's the value of Date(0), but in my case, the values correspond to the average of a whole month, not a concrete date.

How can I get rid of that 12/30/1899?

Thanks.

image.png

Labels (3)
1 Solution

Accepted Solutions
morenoju
Partner
Partner
Author

Hi @wfaez , I ended up using interval() instead of time() in my data load:

Interval(Round(Frac(Time("start_date",'hh:mm')),1/96),'hh:mm') as time_15min,

I hope it helps.

View solution in original post

3 Replies
morenoju
Partner
Partner
Author

I've tried the same in Qlik Sense Enterprise November 2019 and there it does not happen. In Qlik Sense Enterprise April 2020 it does happen though.

Any idea?

wfaez
Contributor
Contributor

Hey Guys, Any idea how solve this issue? thks!

morenoju
Partner
Partner
Author

Hi @wfaez , I ended up using interval() instead of time() in my data load:

Interval(Round(Frac(Time("start_date",'hh:mm')),1/96),'hh:mm') as time_15min,

I hope it helps.

View solution in original post