topic Re: Re: Re: Re: help with a graph in QlikView

help with a graph

Mon, 29 Sep 2014 17:22:58 GMT

I have a table with dates. Monday dates to be specific (9/1/2014, 9/8/2014, 9/15/2014, 9/22/2014..etc)

I use a graph to display the data and on my x-axis, I want to cycle between Weeks and Months.

I tried to create a cycle group with the week from my table and then I used the master calendar 'Months' to view in months but whenever I see it on the graph, it shows me as 1,2,3,4,5,6,7,8,9,10,11,12 and only shows the month name if I only select one month...

any idea on how to fix this?

Re: help with a graph

JonnyPoole — Mon, 29 Sep 2014 19:51:14 GMT

Here is a sample with Month Names (MMM) and weeks (Monday Dates).

In the month field in the cycle i used: =left(MonthName(Date),3) to format a MM/DD/YYYY as MMM and the Date field to show the Monday Dates (weeks)

Does that help ?

Re: help with a graph

Mon, 29 Sep 2014 20:16:46 GMT

It is giving me a 'No numeric values on x-axis' error... any idea on why this is happening?

Re: help with a graph

JonnyPoole — Mon, 29 Sep 2014 20:21:22 GMT

i'm guessing you need to uncheck 'continuous' on the Axis tab of the chart properties. I didn't have that checked in the sample screenshot above. Let me know if you see any issues disabling it.

Re: Re: help with a graph

Mon, 29 Sep 2014 20:30:05 GMT

That helped but take a look at the picture attached.

1) Is there any way to limit the number of weeks shown on the graph without choosing 'continuous' option

2) how can I also show year at the end of month (i.e Sept '14, Oct '14, etc)

Re: Re: help with a graph

JonnyPoole — Mon, 29 Sep 2014 20:42:54 GMT

Try using this expression for month to format the Date into a month of your need:

Date(Date,'MMM-YY')

or maybe

Date(Date,'MMM YY')

For the X axis, on the axis tab, try changing the labels to be a 45 degrees and on the presentation tab under chart scrolling, enable the x-axis scrollbar after 15 or 20 values.

You can also change the font size of the label to 7 or 8pt font on the axis tab. See if that helps somewhat.

Re: Re: Re: help with a graph

Mon, 29 Sep 2014 21:32:45 GMT

The 'Date(Date,'MMM-YY')' does not work correctly. see attached picture. It shows a month and year for each monday date..

Re: help with a graph

MarcoWedel — Mon, 29 Sep 2014 22:02:33 GMT

please post randomized sample app, otherwise it's just guessing ...

thanks

regards

Marco

Re: Re: help with a graph

Mon, 29 Sep 2014 22:35:36 GMT

Marco - here is an example. For some reason, when I click on the 'Month' cycle, it says no data available...

The goal is to have the graph be able to cycle between weeks and months.

I would like this format (month-yy) when it is in Months (Aug '14, Sept '14, Oct '14, Jan '15, etc) if possible

Re: Re: Re: Re: help with a graph

JonnyPoole — Tue, 30 Sep 2014 00:05:53 GMT

Got it.

With your YYYYWW format yoiu can use this to get the MMM 'YY format:

= left(MonthName( MakeWeekDate( left(Week,4) ,right(Week,2))),3)& ' ' & chr(39) & mid( Week,3,2)

Re: Re: Re: help with a graph

MarcoWedel — Tue, 30 Sep 2014 07:36:54 GMT

Hi,

your example has no month dimension included.

The week dimension again is just an integer that looks like a weekname.

I tried to generate a cyclic group using these expressions:

For Week:

=Dual(Week,MakeWeekDate(Left(Week,4),Right(Week,2)))

For Month:

=MonthName(MakeWeekDate(Left(Week,4),Right(Week,2)))

The result looks like:

better use expressions like these at script level to create new fields from your source dates.

hope this helps

regards

Marco

Re: help with a graph

Tue, 30 Sep 2014 14:10:46 GMT

Thank you Jonathan and Marco for your help!!

Re: Re: Re: help with a graph

MarcoWedel — Tue, 30 Sep 2014 14:53:35 GMT

you're welcome

regards

Marco