topic Calculate Year over Year data on a Chart in QlikView

Calculate Year over Year data on a Chart

Tue, 17 Jun 2014 13:04:13 GMT

Hi, I hope someone out there will be able to help me with this one, I'm really struggling. I've read numerous threads on here about YoY but cannot seem to find anything that fits with my requirements....

I'm trying to show Year over Year data alongside current year data on a chart. I can show the current year's data accurately with the following expression:

=num(sum([UNIT.SALE_PRICE])/sum([UNIT.MARKET_PRICE]),'##.##%')

but then need to do the same expression but to show data for the previous year

Please help, thanks

Re: Calculate Year over Year data on a Chart

tresB — Tue, 17 Jun 2014 13:06:45 GMT

Not sure if understood right. If you take Year field as dimension and the expression as yours, doesn't it work? If you don't want all years, you can limit them using dimension limit, or, using set analysis.

Re: Calculate Year over Year data on a Chart

Tue, 17 Jun 2014 13:09:46 GMT

Hi, sorry, no, I've got month as the dimension, so that I can show the data on the chart by month, but I need to show the previous years stats too

Re: Calculate Year over Year data on a Chart

Tue, 17 Jun 2014 13:16:00 GMT

This is what I'm trying to create:

Re: Calculate Year over Year data on a Chart

tresB — Tue, 17 Jun 2014 13:17:36 GMT

See this blog post: Year-over-Year Comparisons