Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

GROSS PROFIT

I have more than 100,000 lines showing invoice data. Few lines are shown below.

Invoice NOPurchase AmountSold Amount
INV001100125
INV002125130
INV003140148
INV004150165
INV005200250

I want table as below

Invoice NOPurchase AmountSold Amount% Profit
INV00110012520.00%
INV0021251303.85%
INV0031401485.41%
INV0041501659.09%
INV00520025020.00%
TOTAL71581812.59%

Kindly help me.

1 Solution

Accepted Solutions
MVP
MVP

Re: GROSS PROFIT

1 - sum(PurchaseAmount) / sum(SoldAmount)

23 Replies
Not applicable

GROSS PROFIT

Use this:

([Sold amount]-[Purchase Amount])/[Sold Amount]

Go to Number Tab:

Select Fixed to: 2 Dec

Tick on checkbox "Show in %age"

Not applicable

GROSS PROFIT

This is already done and I am getting TOTAL for "Purchase Amount" and "SOLD AMOUNT" but not getting total for % PROFIT.

Not applicable

GROSS PROFIT

Hi,

I think Erika giving the correct answer, if not that is exactly, what you want?

A little more information would be good.

Regards

Gabriel

Not applicable

GROSS PROFIT

I want total at bottom for Purchase Amount, Sold Amount & % Profit.....

Not applicable

GROSS PROFIT

If you are using a pivot table, you need to go to presentation tab and click show partial summaries for the top dimension, or change the table to a straight table

Not applicable

GROSS PROFIT

Use:

if u r using Pivot table:

Sum(

([Sold amount]-[Purchase Amount])/[Sold Amount]

)

Not applicable

GROSS PROFIT

Thanks for your response. Sorry but I am not getting TOTAL by using PIVOT TABLE for % Profit

Re: GROSS PROFIT

Hi,

See the attached sample for clearity

And suntotal of Purchase Amount, Sold Amount & % Profit.....

By the help of straight table you get this in pivot it is not possible for the expression, there you do only on dimensions.

Regards

Anand

Not applicable

GROSS PROFIT

Can u upload ur Sample App.

Community Browser