Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to calculate month-on-month comparison?

QQ截图20140623165458.png

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

QQ截图20140623170612.png

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

10 Replies
Not applicable
Author

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.