topic Re: Fill the rows with aove value? in QlikView

Fill the rows with aove value?

qlikuser222 — Wed, 22 Mar 2017 13:41:06 GMT

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 — Wed, 22 Mar 2017 13:45:55 GMT

Hi Nicholas,

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

Regards,
H

qlikuser222 — Wed, 22 Mar 2017 13:56:50 GMT

Thanks for reply,

But its not giving the expected results.

Anil_Babu_Samineni — Wed, 22 Mar 2017 14:10:04 GMT

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 — Wed, 22 Mar 2017 15:05:38 GMT

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 — Wed, 22 Mar 2017 15:13:39 GMT

Attaching a sample

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