topic Re: Appending to a list in a script in QlikView

Appending to a list in a script

raynac — Tue, 10 Dec 2013 17:36:11 GMT

I have a hardcoded list of statuses in my database. I created the status list below so that we "translate" the statuses into something meaningful to the client. Until last week these were static and non-configurable.

We have added a table to our database - it will only ever contain a single record so that our clients can add a single configurable status to their own databases. It can be whatever two letter code they want, and whatever description they want.

As a result, this newly configured status now needs to be added to the previously static list as a selector.

1) Is this even doable?

2) If so, how?

I have tried importing the record and then adding the two fields I imported into the listing but I get the name of the field as a string, not the contents of the field.

What am I missing? Anything to point me in the right direction would be appreciated!

Here is what I tried:

LOAD

"sc_status_code",

"status_description"

;

SQL SELECT *

FROM scaltstat;

booking_status_descriptions:

load * inline [

'Current Booking Status', 'Booking Status Description'

qt, 'Quote/Proposal'

tn, 'Tentative'

cf, 'Confirmed/Definite'

xl, 'Cancelled'

po, 'Posted'

sc_status_code, status_description

];

Re: Appending to a list in a script

Tue, 10 Dec 2013 17:44:41 GMT

Hi,

A quick reply and sorry if I am wrong.... but... how about....:

TheFullList:

LOAD

sc_status_code,

status_description;

SQL SELECT * FROM scaltstat;

Concatenate (TheFullList)

Load * InLine [sc_status_code, status_description

....

...
];

Basically I think you are missing a Concatenate

Re: Appending to a list in a script

Tue, 10 Dec 2013 18:01:33 GMT

Hello;

If I understand you want to concatenate table 1 to table 2 (sc_status_code and status_description) and you can try this:

booking_status_descriptions:

load * inline [

'Current Booking Status', 'Booking Status Description'

qt, 'Quote/Proposal'

tn, 'Tentative'

cf, 'Confirmed/Definite'

xl, 'Cancelled'

po, 'Posted'

];

LOAD

"sc_status_code" as [Current Booking Status],

"status_description" as [Booking Status Description]

;

SQL SELECT *

FROM scaltstat;

Or if you want to load SQL table try this:

booking_status_descriptions:

LOAD

"sc_status_code" as [Current Booking Status],

"status_description" as [Booking Status Description]

;

SQL SELECT *

FROM scaltstat;

load * inline [

'Current Booking Status', 'Booking Status Description'

qt, 'Quote/Proposal'

tn, 'Tentative'

cf, 'Confirmed/Definite'

xl, 'Cancelled'

po, 'Posted'

];

Tell me if it works.

Re: Appending to a list in a script

raynac — Tue, 10 Dec 2013 20:20:55 GMT

Hi Tyrone...

Thank you SO much for your response! I think this would have worked, but I think I implemented it incorrectly. I am on my way out for the day so I am going to try it again tomorrow, purely for curiousity in case this comes up again in future!

Re: Appending to a list in a script

raynac — Tue, 10 Dec 2013 20:21:41 GMT

Hi Oswaldo,

I tried the second option and it worked like a charm!! Thank you so much for taking the time to respond 😄

Rayna