topic Re: Month on Month calculations in QlikView

Month on Month calculations

Thu, 23 Jul 2015 03:08:03 GMT

Hi, I have a graph which displays the number of items for different months, there is a value for each month. I want to create another graph which will display the month-on-month for each item as a similar line chart.

For example the value for Feb would be

Month-on-Month (Feb) = (Items in Feb) / (Items in Jan) -1

I'm having trouble getting the values for previous month for each month, have tried a few set expressions but don't seem to work. Is there any way to get the value of previous month for each month using a set expression.

Will appreciate any help regarding this

Thanks

Varun

Re: Month on Month calculations

MayilVahanan — Thu, 23 Jul 2015 09:31:06 GMT

May be try like this

Sum(Exp) / Above(Sum(Exp))

Month in ascending order

Re: Month on Month calculations

senpradip007 — Thu, 23 Jul 2015 09:55:43 GMT

Hi Mayil,

Its working for continuous period. But for selected period "Above()" function is not fruitful. Pls help.

Re: Month on Month calculations

MayilVahanan — Thu, 23 Jul 2015 10:02:27 GMT

In that case, you need to bring "flag" for previous month.

Re: Month on Month calculations

sunny_talwar — Thu, 23 Jul 2015 10:19:40 GMT

Or Try this:

Sum(Exp) / If(Sum(Exp) > 0, Above(Sum({<Period = >}Exp)))

Re: Month on Month calculations

senpradip007 — Thu, 23 Jul 2015 10:24:20 GMT

Can you please explain bit more ??