topic Divide two variables in a Chart Expression in QlikView

Divide two variables in a Chart Expression

Wed, 25 Nov 2020 16:16:04 GMT

I have two variables "vGrowth" and "vValue". these values are dispayed in a straight table and the values appear to be correct.I want to divide these two variables and display in a pivot table . I have used the following expression in the chart :

$(vGrowth) / $(vValue).

However it is Summing both the variables instead of dividing.

Also I have tried using the folowing expression as well :

DIV(vGrowth,vValue).

This is resulting in all Zero values.

Is this the correct way of dividing two variables?

Please help.

Re: Divide two variables in a Chart Expression

swuehl — Wed, 14 Dec 2016 10:03:59 GMT

It depends on how these variables are defined.

Maybe just enclose each dollar sign expansion in (..):

( $(vGrowth) ) / ( $(vValue) )

But to tell more, you need to post your exact variable definition (best by posting a small sample QVW)

The Magic of Variables

The Magic of Dollar Expansions

Re: Divide two variables in a Chart Expression

william_allen — Wed, 14 Dec 2016 10:05:34 GMT

This works for me.

$(vGrowth) / $(vValue)

Check the attached QVW that has a pivot table with some generated data and the division of variables as the expression.

Hope this helps.

Re: Divide two variables in a Chart Expression

Wed, 14 Dec 2016 11:31:00 GMT

Thanks Stefan.

I just missed the (....) .

The expression is working fine now.

Re: Divide two variables in a Chart Expression

swuehl — Wed, 14 Dec 2016 11:45:00 GMT

You're welcome.

If your request is resolved, then please close this thread.

Qlik Community Tip: Marking Replies as Correct or Helpful