topic Re: grouping date on x axis in QlikView

grouping date on x axis

josephinetedesc — Thu, 15 Jan 2015 02:50:41 GMT

Hi I have about 1000 data points, of dates and widgets sold. I want to make a graph with date on the axis, however i want it to show as a very long trend graph. I want to show from 2001 Jan to Dec then 2002 , jan to Dec then 2003 Jan to Dec. I am having a lot of trouble.

I have tried adding the dimension Year(saledate)&'/'Month(saledate) and sort by saledate - but still get very odd graph.

Re: grouping date on x axis

sushil353 — Thu, 15 Jan 2015 04:29:26 GMT

Hi,

Try adding dimension using monthname function

MonthName(saledate) as monthyear

HTH

Sushil

Re: grouping date on x axis

rwunderlich — Thu, 15 Jan 2015 04:33:40 GMT

Try setting on "Continuous" in the Axes tab.

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: grouping date on x axis

josephinetedesc — Thu, 15 Jan 2015 05:53:08 GMT

Sushil Kumar this is what I get: still cannot sort i don't know if you can see it but the 1st and last valure are Nov 2002 and Dec 2002 - the rest seems ok!

Re: grouping date on x axis

josephinetedesc — Thu, 15 Jan 2015 06:02:49 GMT

Actually I think it is correct ... I just redid the chart

1. changed the chart (chose it from Right click the sheet )

2. expanded and saw that the correct sequence ...

Thank you