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: 
rittermd
Master
Master

Date Issue in Line Chart

I have the following dimension:

Year(Most_Recent_Hire_Date)

When I use this in a bar chart I get what I would expect 2014,2015,2016, etc.

When I use this in a line chart I get 2.015k,2.0152k,2.0154k

Why is it calculating it differently from chart to chart type and what do I need to do in the line chart to have it display correctly?

8 Replies
sunny_talwar

I think it is the formatting issue... May be select Custom format and see if that fixes the issue

rittermd
Master
Master
Author

It is a dimension so there is not option for custom format

sunny_talwar

How about using Num() function

Num(Year(Most_Recent_Hire_Date))

rittermd
Master
Master
Author

Nope.  That doesn't change anything in the line chart.

rittermd
Master
Master
Author

It displays ok in a combo chart.  But I get other issues.

I guess I am stuck with a bar chart.

sunny_talwar

What version of Qlik Sense are you on? May be update if possible?

rittermd
Master
Master
Author

We are still on 3.1.  I have asked to get an update on the schedule since 3.2 just came out.  I guess I will just have to wait and see i that fixes it.  Thanks for your help as usual.

Not applicable

Any luck? i am using 3.1 SR4 as well but it seems to be displaying correctly on line charts