Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Contributor III

?

.

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: how to replace only null values?

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
Highlighted
MVP
MVP

Re: how to replace only null values?

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
Highlighted
Not applicable

Re: how to replace only null values?

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

Highlighted
MVP
MVP

Re: how to replace only null values?

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