Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
morenoju
Partner - Specialist
Partner - Specialist

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 (2)
1 Solution

Accepted Solutions
morenoju
Partner - Specialist
Partner - Specialist
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 - Specialist
Partner - Specialist
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 - Specialist
Partner - Specialist
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.