topic Re: How to calculate month-on-month comparison? in QlikView

How to calculate month-on-month comparison?

Mon, 23 Jun 2014 09:07:54 GMT

As we can see from the picture above,there are two columns and two lines in the chart.

I have already add two columns and the expressions are used as follows:

ADamount: sum({$<cal_month={"2014*"}>}[AD_amount])/1000

Receiveamount: sum({$<cal_month={"2014*"}>}[receiveamount])/1000

But how to add two lines as month-on-month comparison?

tresB — Mon, 23 Jun 2014 09:17:23 GMT

Use combo chart. Four expressions. In the expression tab, you can select an expression and choose bar/line from display options.

Mon, 23 Jun 2014 09:20:25 GMT

I know it need combo chart. But how to write the expressions?

Tue, 24 Jun 2014 04:05:56 GMT

Can anyone solve the problem?

Tue, 24 Jun 2014 04:16:50 GMT

Can't you try using above.

Sum(AD_amount)- Sum(above(AD_amount)) as the MOM Expression?

Tue, 24 Jun 2014 06:14:54 GMT

Thank you for your reply.

But when I use your expression,it doesn't show any number,why?

Tue, 24 Jun 2014 06:24:13 GMT

Oh, I've modified the expression to:

sum({$<cal_month={"2014*"}>}[AD_amount])/1000/Above(sum({$<cal_month={"2014*"}>}[AD_amount])/1000)-1

And it works.

Thank you very much.

Tue, 24 Jun 2014 06:39:36 GMT

can you mark the thread as 'Answered' please?

Tue, 24 Jun 2014 06:41:38 GMT

Done. Thank you very much.

Mon, 20 Oct 2014 18:40:05 GMT

hi Joy, would you mind share this chart.

Tue, 21 Oct 2014 05:26:41 GMT

I'd like to share the chart,but it's one part of my report. I don't know how to spilt the chart from the whole report.