Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to compute Sales / Net Profit in % ?

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

4 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

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

Regards

ASHFAQ

paulyeo11
Master
Master
Author

My QV doc

ashfaq_haseeb
Champion III
Champion III

Hi,

have a look at attached application.

Another option could be

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

Regards

ASHFAQ

tresesco
MVP
MVP

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