topic Re: calculate margin error in QlikView

calculate margin error

userid128223 — Wed, 24 Oct 2012 14:58:12 GMT

I am trying to calculate margin within straight table expression.

My formula works until this point.

Sum (([order tabl.qtyship] * [order table.Unit Price]) - ([order table.qtyship] * [order table.Unit Cost]))

however when i start dividing the whole thing with gross sales, in order to get margin. it stops working.

Sum (([order tabl.qtyship] * [order table.Unit Price]) - ([order table.qtyship] * [order table.Unit Cost])) / Sum ([order tabl.qtyship] * [order table.Unit Price])

I have tried putting brackets on entire expression without any results.

what am i doing wrong. Please explain.

Re: calculate margin error

Wed, 24 Oct 2012 15:05:15 GMT

I can't see anything wrong with the expression so this might simply be a number formatting issue, go to the presentation tab and for that expression make sure that "Expression Default" is un-checked, then set your formatting for a number and make sure that "Display as percentage" is switched on at the bottom.

Re: calculate margin error

whiteline — Wed, 24 Oct 2012 19:05:16 GMT

Hi.

What is the dimension of your straight table ?

How many different values of [order tabl.qtyship] and [order table.Unit Price] do correspond to one dimension value ?

Re: calculate margin error

Thu, 25 Oct 2012 05:40:25 GMT

Hi,

below expr may help u.

Sum( (([order tabl.qtyship] * [order table.Unit Price]) - ([order table.qtyship] * [order table.Unit Cost])) / ([order tabl.qtyship] * [order table.Unit Price]) )