topic Re: Margin Calculation in QlikView

Margin Calculation

qlikviewaf — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

i created a report with the following expression.

I would like to add an expression and use the [COGS YTD $(vYear)] directly in the expression, is something possibile?

which is the syntax?

Imagine another expression called MARGIN where the expression is = [COGS YTD $(vYear)] / [Revenue YTD]

Re: Margin Calculation

Anil_Babu_Samineni — Fri, 21 Jul 2017 14:03:52 GMT

Yes, This label of expression we can use like Measure with in the expression. Will you provide more info related same

Re: Margin Calculation

Fri, 21 Jul 2017 14:06:09 GMT

='COGS YTD $(vYear)'

Re: Margin Calculation

qlikviewaf — Fri, 21 Jul 2017 14:12:38 GMT

Not working.. look

Re: Margin Calculation

Fri, 21 Jul 2017 14:17:02 GMT

Works for me. Can you show me the definition of your year variable?

Re: Margin Calculation

Anonymous — Fri, 21 Jul 2017 14:18:19 GMT

When I did this calculation I put the 2 amounts/calculations (vCOGS and vREVENUE) into variables then directly input the expression into the Margin% column [ =(vCOGS - vREVENUE) / vREVENUE ]