Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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?
Hey Guys, Any idea how solve this issue? thks!
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.