topic selecting data based on field values in QlikView

selecting data based on field values

Thu, 18 Aug 2011 16:35:23 GMT

I am new to qlikview and I am sure this is a simple issue. I have a excel file that has order data in it. Some of the records are orders that have been billed and others are items that will be billed. My current load statement loads all records regardless of the field value "order status". In a chart, I would like to have one column have just the "billed" items and another column have just the "backlog" items. What is the most appropriate way to do this. Should I create two load statements that load the same file and just select the appropriate data( which I assume causes the file to be read twice) or is their some way to make this selection the the expression area of the chart? If you do this by having two load statements do you need to convert the labels to be something different so they dont conflict? Thanks for any help.

selecting data based on field values

Thu, 18 Aug 2011 17:37:56 GMT

When you load the data, I assume you will have the ability to determine what orders are billed and which are backordered. Cant you create an attribute (like Billing Status) that has the current state for the record? I assume you would know the logic to determine what is billed and what is backordered. Once you have that, create a chart object and use the Billing status dimension.

selecting data based on field values

Thu, 18 Aug 2011 18:02:00 GMT

I just figured this out. I do have a billing status and just figured out how to conditionally sum the order amounts based on that status. Thanks