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.
mputhiadeloitte
New Contributor

Difference of two values in place of first value

Hi,

I am trying to calculate the difference of amounts in two rows but I am unable to achieve it.

I want to calculate the difference of Par amount for Non-SBL Holdings and Combo and show this difference against Non SBL Holdings.

Please help me with the same.

Please have a look at the attached screenshot.

Regards,
Manu

Tags (2)
3 Replies
mputhiadeloitte
New Contributor

Re: Difference of two values in place of first value

Hey,

Is there any Moderator who can help me with this issue?

It has not yet been approved. Please approve it.

Regards,

Manu

millan123
Contributor II

Re: Difference  of two values in place of first value

Hi,

You can try like

Sum(Columna-Columnb) and add this measure to that table

rupamjyotidas
Valued Contributor

Re: Difference of two values in place of first value

Try using above() function .

For Ex:

Above(Paramount)-Paramount.

Try to read about the function.