Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
zhuravlevleonid
Contributor II
Contributor II

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

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?

1 Solution

Accepted Solutions
raman_rastogi
Partner
Partner

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

The Above Function

Raman

View solution in original post

3 Replies
maxsheva
Creator II
Creator II

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
Partner
Partner

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

The Above Function

Raman

andreidonati
Contributor
Contributor

Thanks!