Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rajaiqliksense
New Contributor

Subtract value from one row to another row in QLIK SENSE ( Straight table )

Hello friends,

Anybody there to help urgently.

I have a requirement in P&L where need to calculate consolidation and i'm unable to calculate the

consolidated EBITA (i.e Adjustment figure have to be subtracted after summing up rev and expense from all companies

to derive consolidated EBITA)

I've adjustment value comes in the format of  [COMP1, COMP2, 'REVENUE' ACC_GRP, ADJUSTAMENT VALUE{10}],

[comp1,comp2,'expense' acc_grp, adjustment value {20}]

how could i apply adjustment value for EBITA calculation

I used this formula for adding adjustment figure of expense with ebita but failed to achieve

sum(TOTAL (AGGR(
(IF(MATCH(CON_VW, $(Vconcat)),sum(ADJ),0))

,CON_VW)))

here CON_VW -> COMP1, COMP2

AND Vconcat result would be COMP1,COMP2

COMP1  COMP2  CONSOLIDATED VALUEADJUSTMENT finalTOTAL
          
REV100 REV100 200-10REV190
EXP80 EXP20 100-20EXP80
EBITA20 EBITA80 100 EBITA(output)110

 

I tried things in pivot, and working on straight table after pivot failure

Please kindly help n this, as its very urgent

 

Thanks & Regards

Raja

2 Replies
OmarBenSalem
Esteemed Contributor

Re: Subtract value from one row to another row in QLIK SENSE ( Straight table )

Can please simplify what u're aiming to do?

example of how to present:

What I have

What I want to achieve; with some data (3 to 4 lines)

Thanks

I won't lie to u, I did not understand a thing..

dilipranjith
Valued Contributor II

Re: Subtract value from one row to another row in QLIK SENSE ( Straight table )

Community Browser