Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

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
MVP
MVP

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
MVP
MVP

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