Discussion Board for collaboration related to QlikView App Development.
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)
I want the output as below. So where ever it starts null it should pick up the above value.
Thanks in advance.
Go to 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
In expressions tab you have an option to accumulate the values:
Thanks for reply,
But its not giving the expected results.
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,
Attaching a sample
Second expression uses Column(2) and the third one uses Label