6 Replies Latest reply: Dec 9, 2016 11:02 AM by Chris Waterworth

# Hide rows in tab

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,

• ###### Re: Hide rows in tab

Add the following set to all your expressions

• ###### Re: Hide rows in tab

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

• ###### Re: Hide rows in tab

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)

• ###### Re: Hide rows in tab

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

• ###### Re: Hide rows in tab

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

• ###### Re: Hide rows in tab

Not sure, but may be this:

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