topic Re: Profit&Loss in QlikView

Profit&Loss

mohan2391 — Fri, 27 Nov 2015 06:18:21 GMT

i have 2 fields as Amount & name. I want to show the families which r in profit & which r in loss seperately. How to do it ? How can i show ?

If amount is in +ve it means profit & if -ve it means loss.

its_anandrjs — Fri, 27 Nov 2015 12:57:56 GMT

Hi,

Check the attached app.

Regards

Anand

its_anandrjs — Fri, 27 Nov 2015 15:29:44 GMT

Hi,

If you have any data so provide that so we have look out the solution otherwise if this your answer so please check.

Regards

Anand

Fri, 27 Nov 2015 16:28:24 GMT

Hi,

Try to put this in the script.

if(amount>0,Profit,Loss) as Category.

zkn_0247 — Fri, 27 Nov 2015 16:40:47 GMT

In load script define condition if(amount <0,'loss','profit') as pnl_flag. now you can group your data on the basis of this flag.

mohan2391 — Mon, 30 Nov 2015 06:27:19 GMT

Thank You.......