QlikView App Dev

[#1]

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?

[JonnyPoole]

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 ?

[#3]

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

[JonnyPoole]

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.

[#5]

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)

[JonnyPoole]

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.

[#7]

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

[MarcoWedel]

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

thanks

regards

Marco

[#9]

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

[JonnyPoole]

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)