topic calculate two column in QlikView

calculate two column

Mon, 19 Apr 2010 07:12:22 GMT

dears,

i want to calculate two column to get the total sales. i have two column one for price and other one for the cost . i want to get the gross and net profit from this two column.

regards

Abdullahkn

calculate two column

Mon, 19 Apr 2010 07:15:46 GMT

Hi Adbullah,

Create one more expression as "Gross Sales" = Sum(Price)

One more expression as "Profit" = sum(Price)-Sum(Cost)

Regards

Rajesh

calculate two column

Mon, 19 Apr 2010 07:36:38 GMT

hi Rajesh

i made two expression as you said but i got the total of price and total of cost i want to merge it to be one answer

thanks

Abdalla

calculate two column

Mon, 19 Apr 2010 07:42:20 GMT

Hi Abdulla,

Pls share the application so that it will easier to look into it.

You can also add Sum(Price) + Sum(Cost) or Sum(Price + Cost) if you want.

Regards

Rajesh

calculate two column

Mon, 19 Apr 2010 08:23:57 GMT

Rajesh,

in the expression i did like this but still not calculate the gross profit

please tell me how to do this .

Sum(Price) + Sum(Product-Cost)

Abdalla,

calculate two column

Mon, 19 Apr 2010 08:26:22 GMT

Hi,

Pls share the application with dummy data.

Regards

Rajesh

calculate two column

Mon, 19 Apr 2010 08:34:35 GMT

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/1122.Book1.xls:550:0]

calculate two column

Mon, 19 Apr 2010 08:51:33 GMT

Hi Adbulla,

Pls find the attached application for your refer.

Regards

Rajesh

calculate two column

Mon, 19 Apr 2010 08:55:37 GMT

Hello Abdullahkn,

Please find attached a file for your reference. Hope i understood your question.

Regards,

Ankur