4 Replies Latest reply: Jul 13, 2014 10:14 PM by Ramkumar Ramagopalan RSS

    Pull in rows only up till a column value reaches certain sum

      Hi,

       

      Is there any way to pulll data in qlikview only till a column value reaches certain sum. For example, attached spreadsheet has three columns; Priority, Project, & Budget. I want qlikview to first sort the data by priority, then sort by name, then pull projects only till the sum of budget reaches $2.5 M. So here in this example only project from Project A to Project I will be pulled in and rest will be ignored. Any way to do this? Every help is very much appreciated.

       

      Thanks!

      Sid