Fill the rows with aove value?

[qlikuser222]

Hi All,

I have a requirement and need your help.

assuming below is straight table. I have a dimension and expression (dummy one)

ID    Sum(order total)/sum(total)

1           100

2            200

3           -

4           -

5           -

6           -

7           -

I want the output as below. So where ever it starts null it should pick up the above value.

ID    Sum(order total)/sum(total)

1           100

2            200

3           200

4           200

5           200

6           200

7           200

Thanks in advance.

[hector_munoz]

Hi Nicholas,

In expressions tab you have an option to accumulate the values:

Regards,
H

[qlikuser222]

Thanks for reply,

But its not giving the expected results.

[Anil_Babu_Samineni]

May be this?

If(Sum(Sales)=0, Above(Sum(Sales)), Sum(Sales))

Or in script

IF (len(trim(Sales)) = 0 or Sales = ' ' or IsNull(Sales), peek('Sales'), Sales) AS Sales,

[sunny_talwar · Accepted solution]

May be this

If(Len(Trim(Sum(order total)/sum(total))) = 0, Above(ExpressionLabel), Sum(order total)/sum(total))

Here ExpressionLabel is the name of the expression label or you can use Column() function

[sunny_talwar]

Attaching a sample

Second expression uses Column(2) and the third one uses Label