Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
jayaseelan
Contributor III

Subtract Two Rows using expression

Hi Experts,

I need to subtract the two rows and the result should be feed to another column.

I have attached my Data in excel, Please any one give me the solution for attached data.

Capture.PNG

thanks,

1 Solution

Accepted Solutions
devarasu07
Honored Contributor II

Re: Subtract Two Rows using expression

Hi,

Refer to the attached sample output. tks

5 Replies
MVP
MVP

Re: Subtract Two Rows using expression

Try a chart inter record function, Above():

=Rangesum( Value, -Above(Value) )

Re: Subtract Two Rows using expression

In case you have more than Value for each Month, you might need to add Sum() or Avg() or whatever you expression is for value

=RangeSum(Exp4Value, -Above(Exp4Value))

jayaseelan
Contributor III

Re: Subtract Two Rows using expression

Thanks for your valuable reply

But using above expression i did't getting my result. can you please give me a example .qvw or .qvf use the data which i have attached.

devarasu07
Honored Contributor II

Re: Subtract Two Rows using expression

Hi,

Refer to the attached sample output. tks

jayaseelan
Contributor III

Re: Subtract Two Rows using expression

Thanks for replied everyone got the output.