topic Re: What does it mean sum({1} 0)? in QlikView

What does it mean sum({1} 0)?

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

Hello everybody,

found in an existing chart in an expression such part: sum({1} 0). What is it?

Full part:

sum ({<...>} Sales - Costs)*correction + sum({1} 0). Is it made for better rounding?

maxsheva — Wed, 07 Feb 2018 11:04:32 GMT

Hi, I suppose it shows all rows even if dimensions have only zero values.

In a normal way when no data in all dimension fields then table is presented as suppressed.

raman_rastogi — Wed, 07 Feb 2018 11:07:07 GMT

Leonid

+ SUM({1}0) Add Zero to all values.

By using this in your expression you can get all dimensions values

For More read this

Raman

Anonymous — Thu, 05 Jul 2018 12:02:03 GMT

Thanks!