How to create additional field name PNL+TYPE = Revenue IF GL_CODE=80020 ?

[paulyeo11]

Hi All

My Table after load raw data to Qlik is look like below :-

SOURCE	GL_CODE_	GL_DESC_	Amount
TDS	80020	LOCAL SALES	205297.31
PMC	5000200	LOCAL SALES	-590387.65

I Wish to make the table as below :-

SOURCE	GL_CODE_	GL_DESC_	Amount	PNL_TYPE
TDS	80020	LOCAL SALES	205297.31	REVENUE
PMC	5000200	LOCAL SALES	-590387.65	REVENUE

Base on condition :- 

SOURCE = TDS , GL_CODE=80020 , PNL_TYPE = Revenue

SOURCE = PMC, GL_CODE=5000200 , PNL_TYPE = Revenue

Can some one advise me how to do it ?

PAul Yeo

SOURCE = TDS GL_CODE=80020 , PNL_TYPE = Revenue

[jochem_zw]

If(GL_CODE=‘80020’ and PNL_TYPE=‘REVENUE’,Amount,0) As RevenueAmount

[Vegar]

In your example all records are classed as REVENUE, in the  future I would recommend to add sample rows that is both true and false in your logic.

I've tried to solve your question by using applymap (See attached qvw). I hope I understood your issue correctly and that it solves your need. 

[paulyeo11 · Accepted solution]

Hi Vegar & Jochem

Thank you very much for reply my post.

Some how this morning with clear mind , i try to check my script again , it work fine .

So i can moving on.

Paul Yeo

[paulyeo11]

Hi Vegar

Your advise is very good. I will remember it .

Thank you

Paul

[Vegar]

Thank you for the nice feedback.

-Vegar