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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
fish417913
Contributor
Contributor

Line Plot X-Axis Manipulation

I have a line plot that deals with employee pay.  The x-axis shows the pay dates (2 pay periods per month) and the problem I've run into is this: the earliest pay date in my data begins in October 2021, yet the line chart has labels for July, August and September of 2021 on the x-axis.  Yet, when I hover over the data that appears to occur in July, the tool tip displays the correct date of October.

I experimented with un-selecting the continuous axis, but this overplots the pay dates and is visually distracting.  

Any ideas on how I can mitigate this issue?  If I could get Qlik Sense to remove the three months in 2021 that do not exist in my data, I would love to learn how.  

Labels (3)
1 Reply
Digvijay_Singh

You mentioned your line chart is showing July, August and September of 2021 on the x-axis even though you don't have data against those months, I feel you have some code in your script generating those months, do you use master calendar in your script? What if you show exact pay date as a 2nd dimension in your chart, I feel it should show two entries per month and it won't overlap I think.

Please share sample app to try few things on your chart..