Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

calculate two column

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

1 Solution

Accepted Solutions
Not applicable
Author

Hi Adbulla,

Pls find the attached application for your refer.

Regards

Rajesh

View solution in original post

8 Replies
Not applicable
Author

Hi Adbullah,

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

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

Regards

Rajesh

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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,

Not applicable
Author

Hi,

Pls share the application with dummy data.

Regards

Rajesh

Not applicable
Author



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



Not applicable
Author

Hi Adbulla,

Pls find the attached application for your refer.

Regards

Rajesh

View solution in original post

Not applicable
Author

Hello Abdullahkn,

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

Regards,

Ankur