topic Re: Chart year comparison in QlikView

Chart year comparison

Anonymous — Fri, 20 Nov 2020 18:02:30 GMT

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

Re: Chart year comparison

robert_mika — Wed, 25 Mar 2015 10:29:19 GMT

Look here for ideas::

Side by Side expressions in Bar Chart | Qlik Community

Clustered-Stacked Column and Bar Charts in QlikView

Re: Chart year comparison

prma7799 — Wed, 25 Mar 2015 10:31:42 GMT

Hi,

Can you post some data?

Thanks

Re: Chart year comparison

jpenuliar — Wed, 25 Mar 2015 11:42:02 GMT

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

Re: Chart year comparison

Anonymous — Wed, 25 Mar 2015 11:56:33 GMT

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

Re: Chart year comparison

jpenuliar — Wed, 25 Mar 2015 12:04:32 GMT

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

Sort by expression :

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

Re: Chart year comparison

sunilkumarqv — Wed, 25 Mar 2015 12:12:10 GMT

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