Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

two column expression

i have this expression

if($(VandL)='Profit',

Fabs(sum({<Flag={'14'},Update_Date={$(vMaxDate)},

[AccCapt]=,[AccCate]=,[AccsubCat]=,[AccDesc]=>}[LBalance]))

,

if($(VandL)='Return',

Fabs(sum({<Flag={'17'},Update_Date={$(vMaxDate)},[AccCap]=,[AccCat]=,[AccSubCat]=,[AccDesc]=>}[LBalance]))

,

if($(VandL)='Net',

(Column(14)-Column(17))

i tried to minus but this not show result what should i do problem is in this

if($(VandL)='Net',

(Column(14)-Column(17))

2 Replies
ajaysingh285
Contributor III
Contributor III

Hi Amber, can u please explain your question at high level or at  business level that makes some sense.

Anil_Babu_Samineni

What column(14) and column(17) returning?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful