Multiplication Script having Issue

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

Hi All,

I have Quantity, Contract Margin in my DB. I am taking these field directly. I am doing on calculation in script level, like:

Quantity * Contract Margin as Margin$.

But if I use this Margin$ field directly in my chart value is not matching. Like:

sum(Margin) -- it is not matching

Instead of that if I use base query in chart like :

sum(Quantity) * sum(Contract Margin) --- it is matching.

Can anyone suggest me why this is happening. How to resolve this.

Thanks,

Sarif

Re: Multiplication Script having Issue

Anonymous — Tue, 04 Apr 2017 09:13:47 GMT

Hi Mohammad,

I think it's the expected behavior. For example, If you have a month as a dimension, and your field is Margin which is Quantity * Contact Margin, The value of the month should be Quantity of month and Contact Margin of Month. So it should be sum(Quantity) * sum(Contract Margin).

I think it's not the mistake of the QlikView as it gives the values of your expression.

Just an opinion.

topic Multiplication Script having Issue in QlikView

Multiplication Script having Issue

Re: Multiplication Script having Issue