topic How to compute Sales / Net Profit in % ? in QlikView

How to compute Sales / Net Profit in % ?

paulyeo11 — Thu, 21 Aug 2014 08:30:08 GMT

Hi All

I have a P&L table which give the P&L summary.

I need to compute the Return of net profit base on sales amt , which is =38.28/76.21=50.22 %

The new compute % it can be put on new table or existing table.

Any input will be appreciated.

Paul

ashfaq_haseeb — Thu, 21 Aug 2014 08:33:32 GMT

Hi,

Go to chart --> Properties --> Number's tab --> Select your Expression --> then select show in % option.

Regards

ASHFAQ

paulyeo11 — Thu, 21 Aug 2014 08:34:08 GMT

My QV doc

ashfaq_haseeb — Thu, 21 Aug 2014 08:38:53 GMT

Hi,

have a look at attached application.

Another option could be

Go to chart --> properties --> Expression --> Select Relative option.

Regards

ASHFAQ

tresB — Thu, 21 Aug 2014 08:41:33 GMT

Perhaps you need to generate such calculated accounts in the script like I showed here: New value as quotient of other two value