Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to insert difference in the same chart

Dear all,

pretty sure (or hoping) that there is a simple answer, but I was not able to track it in other posts. I have a set of sales data, one of the column is YEAR, I have a pivot chart showing sales of this and previous year and I'd like to insert a third column with the difference, I tried multiple ways (wih label for toals) but none is giving the result wanted, or I'm doing something wrong. Now I'm using a second chart, but it's not handy.

Thank you in advance

M.

3 Replies
Anonymous
Not applicable
Author

Did you try:

Column(1) - Column(2)

?

Not applicable
Author

I found the solution (http://community.qlik.com/message/24253#24253) through your sugestion. Thanx

v_iyyappan
Specialist
Specialist

Hi

     I think difference of first two expression in third column right? if right means

use the expression in third column like = column(1) - column(2).

I attached a sample file using pivot table

Regards,

Iyyappan