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

    Hide rows in tab

    Chris Waterworth

        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,