Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlik,
I am building an app that accumlates the valve being stored at a site until it reaches capacity and then is removed.
The accumulation is based on the equation:
rangesum(above(((avg([Increment])),0,RowNo()))
The rest are this equation muliptle and divided by the capacity.
I would like to create a list of just the dates where there are deliveries but can i do the without the above function resetting the values in the rows?
Ideally I would like to just 'hide' those rows where the 'Weeks Loads' are 0.
Can anyone think of a solution? At wits end.
Cheers,
I think the issue is that for a row to hide all the expression in that row needs to equal 0 or null. In your case, since other rows expressions are not 0, you see both 0 and 1 for Week Loads. May be add a if statement for all your expressions other than Week Loads
If(Week Loads Expression > 0, Expression1)
Add the following set to all your expressions
=rangesum(above(((avg({<WeekLoads = {'>0'}>}[Increment])),0,RowNo())))
Not sure, but may be this:
RangeSum(Above(Avg([Increment]), 0, RowNo())) * Avg({<[Week Loads] -= {0}>} 1)
I see how that would work but unfortunately 'WeekLoads' is an expression basically dividing the cumulative by the capacity
I think the issue is that for a row to hide all the expression in that row needs to equal 0 or null. In your case, since other rows expressions are not 0, you see both 0 and 1 for Week Loads. May be add a if statement for all your expressions other than Week Loads
If(Week Loads Expression > 0, Expression1)
Complete amateur question SunnyT but would your Expression1= whatever is already in cell?
Ignore that last one, cracked it SunnyT you are a genius.