topic Re: How to create additional field name PNL+TYPE = Revenue IF GL_CODE=80020 ? in QlikView

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

paulyeo11 — Sun, 23 Feb 2020 06:34:26 GMT

Hi All

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

I Wish to make the table as below :-

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 — Sun, 23 Feb 2020 16:54:56 GMT

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

Vegar — Sun, 23 Feb 2020 17:42:17 GMT

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 — Sun, 23 Feb 2020 21:31:13 GMT

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 — Sun, 23 Feb 2020 22:04:46 GMT

Hi Vegar

Your advise is very good. I will remember it .

Thank you

Paul

Vegar — Sun, 23 Feb 2020 23:12:27 GMT

Thank you for the nice feedback.

-Vegar