Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Items in List Boxes

‌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

1 Solution

Accepted Solutions
MVP
MVP

Re: Items in List Boxes

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.

2 Replies
MVP
MVP

Re: Items in List Boxes

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.

Not applicable

Re: Items in List Boxes

Thank you Jagan.  That helped me out.

Have a great day.

David

Community Browser