topic Re: Stuck with a Cross dynamic board in QlikView

Stuck with a Cross dynamic board

Thu, 24 Apr 2014 13:09:52 GMT

Hi all,

I' ve a problem with my crossed dynamic board. It consists of an Indicator Number and of a set of figures which brings to a total. For information the last 3 are expressions and the others dimensions. In certain cases, if a column is not informed calculates it will not made the result(see the picture)

For information :

Disponible à engager = Montant Glo - Franchise - Frais HE - Cumul ER

Total = Versement D. + Versement I. + Réponse Recours

Balance = Dispo - Total

For example:

If we take the second line of the board, we see that "Cumul Eng. Réa.' so the 'Disponible à engager' too and of the blow the balance also.

How can I calculate them when certain values are not here?!

Thank you largely in advance

Re: Stuck with a Cross dynamic board

whiteline — Thu, 24 Apr 2014 15:04:56 GMT

Hi.

You could use rangesum() function. It calculates the sum of expressions and omit null values.

I guess the problem is that you use '+' '-' signs, and if any operand is null the result is null.

Re: Stuck with a Cross dynamic board

Thu, 24 Apr 2014 15:26:39 GMT

Hi and thx whiteline,

What the difference between Sum() and RangeSum() ? I've try in my expression to use RangeSum([Val1]+[Val2]) for example. I don't have '-' but '0' instead. But that don't solve my problem.

I think your right about the '+' '-' signs but I sure there is a way to deal with null values.

Re: Stuck with a Cross dynamic board

whiteline — Thu, 24 Apr 2014 20:17:21 GMT

Sum - aggregation function that sums the field values.

RangeSum - function that sums expressions, omitting nulls.

null + some expression result = null

ramgesum(null, some expression result) = some expression result

You can read the QV help.

Re: Stuck with a Cross dynamic board

Fri, 25 Apr 2014 08:45:38 GMT

That's works for me thx you whiteline