This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
Pls find the attached application for your refer.
View solution in original post
Create one more expression as "Gross Sales" = Sum(Price)
One more expression as "Profit" = sum(Price)-Sum(Cost)
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
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.
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)
Pls share the application with dummy data.
Please find attached a file for your reference. Hope i understood your question.