3 Replies Latest reply: Jun 10, 2014 10:31 AM by Richard Crittenden RSS

    Using a column within a table to exclude specific rows

      Hi

       

      I'm fairly new to QlikView and I'm trying to teach myself the basics before I undertake any advance training. So any help would be very much appreciated and please excuse the simplicity of my question.

       

      I have a products table (linked to a projects table) which has two columns that are used to identify whether the product(service) has been completed, and if completed, whether it has been invoiced for. With an additional column which is a 'deleteflag' column, which deletes the file from the front end system but not the database. I would like to take these fields into account when putting together a list box, for example:

       

      For every project number there's an x amount of products attached to it. So for each project, I would like a column in my list box that identifies the total value for all uncompleted products, completed products, and a column of those products that have been completed, the value of those that have been invoiced.

       

      I can do simple expressions, (sum and average), and I found that you can use the SET NullValues so that QlikView takes the Nulls into account (for example the Completed column would included Nulls or 0 for any product that hasn't been completed).

       

      Thank you