Hide rows in tab

[#1]

  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,

[vinieme12]

Add the following set to all your expressions

=rangesum(above(((avg({<WeekLoads = {'>0'}>}[Increment])),0,RowNo())))

[sunny_talwar]

Not sure, but may be this:

RangeSum(Above(Avg([Increment]), 0, RowNo())) * Avg({<[Week Loads] -= {0}>} 1)

[#4]

I see how that would work but unfortunately 'WeekLoads' is an expression basically dividing the cumulative by the capacity

[sunny_talwar · Accepted solution]

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)

[#6]

Complete amateur question SunnyT but would your Expression1= whatever is already in cell?

[#7]

Ignore that last one, cracked it SunnyT you are a genius.