Chart year comparison

[Anonymous]

Hi,

se attached image.

How can I get the columns to compare month by month, for example:

2013-Jan 2014 Jan | 2013 February 2014-February | 2013 March 2014-March | ....

insted of

2013 January 2013-February 2013-March 2014-April

[robert_mika]

Look here for ideas::

Side by Side expressions in Bar Chart | Qlik Community

Clustered-Stacked Column and Bar Charts in QlikView

[prma7799]

Hi,

Can you post some data?

Thanks

PM

[jpenuliar]

Hi Marius,

You can make 2 flags on your Date Field, Current_Year & Previous_Year. You then create 2 expression using the flags in  SET Analysis.

an example is on the below link

Qlikview how to:

http://community.qlik.com/docs/DOC-5486

look into "Set Analysis" tab, "Rolling 12 Mths Using Flags" chart

[Anonymous]

It didnt work...

Under the columns you see the problem, it shows January 2013 - Des 2014.
I want it to show January 2013 - January 2014 - February 2013 - February 2014 - March 2013 - March 2014

[jpenuliar]

If I understand it correctly, you want to sort the bars.

Sort by expression :

Match(MonthYear,'Jan-2013','Jan-2014','Feb-2013','Feb-2014'...)

[sunilkumarqv]

Create  below this in your calendar script the bring YearFormat in Dimension

Date(MonthName(Date),'YYYY-MMM')&'-'&Date(MonthName(AddMonths(Date,12)),'YYYY-MMM') as YearFormat