Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for
Did you mean:
Creator III

## ?

.

1 Solution

Accepted Solutions
Not applicable

Hi Agrim,

In Properties Goto--> Dimensions-> Calculated Dimension

use following Expression as if(Late(mm)=0 and Late(mm)='-','Total elapse time',Late(mm))

3 Replies
Partner - Champion III

You can use Alt();

=Sum(Alt([late (mm)], [Total elapsed time])) to replace nulls with the elapsed time values.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Hi Agrim,

In Properties Goto--> Dimensions-> Calculated Dimension

use following Expression as if(Late(mm)=0 and Late(mm)='-','Total elapse time',Late(mm))

Partner - Champion III

I see you want the zero values converted as well. In that case

=Sum(If(len([late (mm)]) = Or [late (mm)] = 0, [Total elapsed time], [late (mm)]))

I am assuming that the '-' are null values.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser