topic Re: Division calculation in script Qlikview in QlikView

Division calculation in script Qlikview

Maveer — Thu, 11 Feb 2021 04:55:11 GMT

Hi All,

Need your help/assistance .

I want to do this below calculation at script level, please let me know, do this is possible.

(sum(Value1))
/(1+(SUM(Value2) / SUM(Value3)))*(SUM(Value2) / SUM(Value3))
)

Value1 , Value2 , Value3 holds both decimal values and non-decimal values

I have applied this in chart expression, when ever i choose different dimensions, numbers keep changing/dropped for same selection. Numbers should be same when ever user choose different dimensions.

Re: Division calculation in script Qlikview

marcus_sommer — Fri, 12 Feb 2021 15:22:53 GMT

That the results change if there are different dimensions used doesn't mean mandatory that anything is wrong.

Of course an unsuitable datamodel with missing/wrong associations between the used tables/fields could cause such effect.

Beside this the available data respectively the data-quality could also have an impact, for example if there are NULL's or any invalid values within the data. This means you need to ensure that you exactly knows which data are in which scenario available because only with this you will be able to decide if the return-values are the expected/wanted results or not and if not to deduce an appropriate way to prevent unwanted results, for example to implement some kind of error-handling by using alt(Field/Expressions, 'Default-Value') or similar stuff to prevent that operands in your expression are NULL or 0 (which wouldn't return a valid result as a divisor) or any other unwanted returns.

With a bit luck you could find the cause if you put all expression-parts as separate expression in your chart. If this don't showed very obvious reasons and/or you couldn't find a simple way to adjust the output in your favour you will need to create a tablebox with all relevant fields (all used dimension- and measure-fields) to see the wrong associations between them respectively the missing/wrong values.

- Marcus

Re: Division calculation in script Qlikview

Maveer — Tue, 02 Mar 2021 18:55:33 GMT

Thanks Marcus.

The calculation which i mentioned is for particular selection. Once that selection is removed, the calculations happened with else condition.

I did the calculations for dollar amount in Script . Then it solved my issue.