topic Calculation in the loading script in QlikView

Calculation in the loading script

Anonymous — Thu, 07 Jul 2011 10:45:47 GMT

Hi there,

Probebly a very simple question:

I would like to make calculations in the loading script, but I stumble on fields without values.

Please take a look at the calculation in the script of the attached file.

When there is no value in one of the fields the result of the calculation is empty, which imo is wrong.

How should I make this calculation?

Or is there an easy way to autogenarate '0' when there is no value in a field?

Thanks,

Dennis.

Calculation in the loading script

brenner_martina — Thu, 07 Jul 2011 10:55:42 GMT

Hi, Dennis,

I would suggest this expression:

If(Not IsNull(Start),Start,0) + If(Not IsNull(Mutatie),Mutatie,0) as Calculation

Re: Calculation in the loading script

Miguel_Angel_Baeyens — Thu, 07 Jul 2011 11:05:22 GMT

Hello Dennis,

You can go to the chart properties, Presentation tab, and set "0" as the Null Symbol instead of the "-" sign. However I don't think this is the best solution. Instead, checking that both fields in the script are not empty and, if they are, assign them a 0, would be harder to code but will return better results:

If(Len(Start) = 0, 0, Start) + If(Len(Mutatie) = 0, 0, Mutatie) AS Calculation

In this case, you have to do this (or use the NullDisplay variable if your ODBC returns nulls) because the "+" operator returns null when one of the values is null. But the Sum() functions returns zero even when some values are null.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Calculation in the loading script

Anonymous — Thu, 07 Jul 2011 11:23:38 GMT

Thanks, that works perfect!

Calculation in the loading script

Anonymous — Thu, 07 Jul 2011 11:25:37 GMT

Thanks, that works also