Items in List Boxes

Sun, 12 Jul 2015 23:21:16 GMT

‌I have a script that pulls the following:

1. A months worth of work orders with the following fields:

a. Location Name

b. Craft

c. Status

I lock those fields in their List Boxes. With the use of NPrinting I create an excel output of the data. The problem I run into is that some months the name of the location is in the Data set and sometimes it is not. It depends on whether there are work orders in a given month under that location. Since the job runs automatically if the name of the location is not present it clears out my locked fields. Then I have to go and lock the fields. The question I have is how do you design a chart with locked fields that checks if a location is present. If it is not then produce a blank chart and if it is then produce the chart. I don't want to blank out the locked fields. Is this possible?

Thanks

David

Re: Items in List Boxes

jagan — Mon, 13 Jul 2015 03:14:29 GMT

Hi,

Load the Location details separately, so that even if the orders exists or not the Location will be there.

WorkOrders:

LOAD

Location Name,

Craft,

Status

FROM DataSource;

Locations:

LOAD

Location Name

FROM AllLocations;

Hope this helps you.

Regards,

Jagan.

Re: Items in List Boxes

Mon, 13 Jul 2015 13:56:33 GMT

Thank you Jagan. That helped me out.

Have a great day.

David

topic Items in List Boxes in QlikView

Items in List Boxes

Re: Items in List Boxes

Re: Items in List Boxes