topic Compare months in QlikView

Compare months

Thu, 21 May 2009 05:13:56 GMT

Hello,

I have a simple table with turnover results by month;

Jan 320493

Feb 293118

Mar 322782

Apr 409382

May 349007

Now I want to make a new column which calculates the difference between the turnover of Mar with Feb for instance. So the third column will show that the turnover of March is ..% higher then the turnover of Feb. And this for every month.

I tried several things like Month-1 but I wasn't succesfull.

Hope you guys can help. Thanks in advance.

Kind regards.

Compare months

johnw — Thu, 21 May 2009 05:22:33 GMT

If by simple table you mean a chart with a "straight table" type, and if "turnover" is the name of the numeric column, you should be able to use =turnover/above(turnover)-1, and display as a percentage. If that doesn't work, or wasn't what you meant, I can get an example working in one way or another.

Compare months

Thu, 21 May 2009 14:06:07 GMT

Hello,

It works! Thank you very much for your prompt reply.

Kind regards,

Niels