topic Re: Showing Specific Dates on a Line Chart with Continuous Axis in QlikView

Showing Specific Dates on a Line Chart with Continuous Axis

ysiroong — Wed, 19 Apr 2017 14:19:26 GMT

I have a chart where I want a data point for every day of the year and have all data points be visible without scrolling. I know I'm supposed to check the box for continuous in the Axis tab, but when I do this, the chart shows the label for the first day of each month.

How can I get it to show the label for the last day of the month (while still plotting the points for all days in between)?

Re: Showing Specific Dates on a Line Chart with Continuous Axis

vishsaggi — Wed, 19 Apr 2017 15:13:49 GMT

Can you share a sample file to look into?

Re: Showing Specific Dates on a Line Chart with Continuous Axis

ysiroong — Wed, 19 Apr 2017 15:54:22 GMT

Document is attached. You'll see that the x axis labels show month / first day. I'd like for it to show the table for the last day instead.

Re: Showing Specific Dates on a Line Chart with Continuous Axis

vishsaggi — Wed, 19 Apr 2017 16:09:03 GMT

May be try this?

ARC:

LOAD

Month(SSDate) as M

, Day(SSDate) as D

, Day(MonthEnd(SSDATE)) AS MED

, FacNumber

, GrossPotential as CYGPI

, SqFtOccpy as CYSFO

RESIDENT Step2

WHERE Year(SSDate) = $(vCurrentYear)

;

JOIN (ARC)

LOAD

Month(SSDate) as M

, Day(SSDate) as D

, Day(MonthEnd(SSDATE)) AS MED

, FacNumber

, GrossPotential as PYGPI

, SqFtOccpy as PYSFO

RESIDENT Step2

WHERE Year(SSDate) = $(vPriorYear)

;

DROP TABLE Step2;

Then use MED in your Chart instead of D.

Re: Showing Specific Dates on a Line Chart with Continuous Axis

vishsaggi — Wed, 19 Apr 2017 16:18:09 GMT

Oh ok, i got it now. Can you also Load your SSDATE in your QV document cos we need to use some MonthEnd and MonthStart functions on that date. Update Like mentioned above:

ARC:

LOAD

Month(SSDate) as M

, Day(SSDate) as D

, Day(MonthEnd(SSDATE)) AS MED

, SSDATE

, FacNumber

, GrossPotential as CYGPI

, SqFtOccpy as CYSFO

RESIDENT Step2

WHERE Year(SSDate) = $(vCurrentYear)

;

JOIN (ARC)

LOAD

Month(SSDate) as M

, Day(SSDate) as D

, Day(MonthEnd(SSDATE)) AS MED

, SSDATE

, FacNumber

, GrossPotential as PYGPI

, SqFtOccpy as PYSFO

RESIDENT Step2

WHERE Year(SSDate) = $(vPriorYear)

;

DROP TABLE Step2;

Once you run adding these fields, please upload the latest sample.

Re: Showing Specific Dates on a Line Chart with Continuous Axis

ysiroong — Wed, 19 Apr 2017 17:17:25 GMT

Data attached with Med and SSDate. There's an issue with the month end column for Feburary due to 2016 being a leap year. Month end for that year is 29 while this year is 28, so the results created duplicates.

Re: Showing Specific Dates on a Line Chart with Continuous Axis

ysiroong — Wed, 26 Apr 2017 14:37:56 GMT

Vishwarath, any updates on this? I still have been unable to show the end of month label on my charts.

Re: Showing Specific Dates on a Line Chart with Continuous Axis

vishsaggi — Wed, 26 Apr 2017 14:48:22 GMT

I am very sorry, it got completely skipped out of my brains. I am not sure what exactly we are looking here. Can you explain it again please. Sorry was preoccupied with other stuff and completely forgot about what we are looking in this.

Re: Showing Specific Dates on a Line Chart with Continuous Axis

ysiroong — Wed, 26 Apr 2017 14:55:07 GMT

No problem.

I have a line chart that maps a data point for every day in a year. I'm able to show all of the data points on the chart by selecting the Continuous checkbox on the Axis tab. I want the x-axis (which shows the date label) to only show a label for the end of the month. However, it looks like Qlikview dynamically determines what dates it will show depending on the amount of space available.

If the chart size is small, QlikView picks the first day of the month (1/1, 2/1,. 3/1). If the chart size is larger, it will show the first day and the 15th day (1/1, 1/15, 2/1, 2/15, 3/1, 3/15). I ONLY want the labels for the end of the month to show (1/31, 2/28/, 3/31).

Re: Showing Specific Dates on a Line Chart with Continuous Axis

vishsaggi — Wed, 26 Apr 2017 15:14:56 GMT

OK, i am not sure if this is what you are looking for? let me know.

Re: Showing Specific Dates on a Line Chart with Continuous Axis

ysiroong — Wed, 26 Apr 2017 15:22:41 GMT

That is not what I'm looking for. If you notice in your chart, you're missing all of the data points in between the visible dates. Below is what I'm able to get. Except I want the label to be for the last date of the month, not the first.

Re: Showing Specific Dates on a Line Chart with Continuous Axis

vishsaggi — Wed, 26 Apr 2017 16:44:12 GMT

Ahh. Ok, i tried that too but it is skewing up the graph. I am not sure how we can get the monthend as label but still have the continuous axis. We might need some help from other experts here. stalwar1‌ swuehl‌ any ideas here?

Re: Showing Specific Dates on a Line Chart with Continuous Axis

sunny_talwar — Wed, 26 Apr 2017 16:57:27 GMT

May not be the best option, but this is the most I was able to figure out

Re: Showing Specific Dates on a Line Chart with Continuous Axis

ysiroong — Wed, 26 Apr 2017 17:18:03 GMT

That wouldn't work at all. It just changes all of the date labels to MM/30. So if I filtered down to a single month, it shows 1/30 1/30 1/30 over and over instead of 1/1 1/2 1/3.

Re: Showing Specific Dates on a Line Chart with Continuous Axis

sunny_talwar — Wed, 26 Apr 2017 18:03:38 GMT

Yup don't know of a way to do this...