Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
qlikuser222
Contributor

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.

Tags (2)
1 Solution

Accepted Solutions

Re: Fill the rows with aove value?

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

5 Replies
hector_munoz
Valued Contributor

Re: Fill the rows with aove value?

Hi Nicholas,

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

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

Regards,
H

qlikuser222
Contributor

Re: Fill the rows with aove value?

Thanks for reply,

But its not giving the expected results.

Re: Fill the rows with aove value?

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,

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)

Re: Fill the rows with aove value?

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

Re: Fill the rows with aove value?

Attaching a sample

Capture.PNG

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