
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 VALUE | ADJUSTMENT | final | TOTAL | ||||
REV | 100 | REV | 100 | 200 | -10 | REV | 190 | ||
EXP | 80 | EXP | 20 | 100 | -20 | EXP | 80 | ||
EBITA | 20 | EBITA | 80 | 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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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..

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
https://community.qlik.com/t5/Qlik-Design-Blog/ValueList-For-those-tricky-situations/ba-p/1476275
