Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser222
Creator
Creator

Fill the rows with aove value?

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.

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

5 Replies
hector_munoz
Specialist
Specialist

Hi Nicholas,

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

22-03-2017 14-45-17.png

Regards,
H

qlikuser222
Creator
Creator
Author

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,

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

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

Capture.PNG

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