topic Graph - Quarters - Actual, Budget, PriorYear in QlikView

Graph - Quarters - Actual, Budget, PriorYear

Fri, 22 Apr 2011 08:34:42 GMT

I was requested to create a graph which shows the Actual, Budget AND PRIOR YEAR figures for the last 8 quarters.

As I have a time axis in the diagramm (quarters) I do not have an idea how to include the Prior Year figures.

Example:

The 1.Quarter 2011 should be the last in the graph, so the first one should be Q2 2009, Q1 2011 should have one bar for the Actuals, one for the Budget and one with the figures of Q1 2010 !!

Hope it is not too hard to solve and that you smart guys here are able to help me 😃

Regards,
Christoph

Graph - Quarters - Actual, Budget, PriorYear

Tue, 26 Apr 2011 09:24:19 GMT

no one has an idea? =(

Graph - Quarters - Actual, Budget, PriorYear

Tue, 26 Apr 2011 09:37:07 GMT

Hi Christoph,

you can include your prior year bar with this expression :

Budget of your actual year :

sum({<[Year]={"$(=max([Year]))"}>}[Budget])

Budget of your prior year :

sum({<[Year]={"$(=max([Year]-1))"}>}[Budget])

That's what you want?

Regards,

Mickaël.