Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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