Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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,

 

1 Solution

Accepted Solutions
sunny_talwar

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)

View solution in original post

6 Replies
vinieme12
Champion III
Champion III

Add the following set to all your expressions

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
sunny_talwar

Not sure, but may be this:

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

Not applicable
Author

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

sunny_talwar

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)

Not applicable
Author

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

Not applicable
Author

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