Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

BarGraph Overlapping Years

Good morning All,

I have data which begins in August 2014 and ends in January 2015. I have created my calendar and have a bar graph by month. This shows January as the first month. How can I get the graph to show January as the last month so as to keep the graph in sequence?

Thanks

H

3 Replies
Highlighted
Not applicable

Hi Herbert

There are a few ways you can use, probably the simplest is to concatenate Month-Year together and then plot on a chart and/or add a sequence number in the script within your calendar dimension and sort by this on the chart.

Hope this helps

Highlighted
MVP
MVP

You can create a field containing Year and Month like this:

YearMonth

Year(Date) & '-' & Month(Date)

When you use this field as a dimension it will sort correctly - by Year and then Month ...

Highlighted

Hi,

In Sort option use Year field and select Ascending.

Regards

Anand