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: 
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))

View solution in original post

3 Replies
jonathandienst
Partner - Champion III
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))

jonathandienst
Partner - Champion III
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