Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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 - Creator III
Partner - Creator III

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

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

Anonymous
Not applicable

Thanks!