topic Help with my Script in QlikView

Help with my Script

hopkinsc — Fri, 06 Aug 2010 12:03:07 GMT

Hi,

Can someone tell me what is wrong with my script please?

I am trying to add 2 field names together so they are displayed as 1 list box instead of 2 seperate ones.

Here is my script.

It is trowing up an error that sais

Help with my Script

jonathandienst — Fri, 06 Aug 2010 12:12:52 GMT

Change the refs to Line Type and Line Description in line 3 back to @1 and @2. These field names do not exist in the data source, so you can't reference them at this point.

Alternatively, do a two level load like this:


Load *,
 [Line Type] & ' - ' & [Line Description] AS [Transaction Type];
Load @1 AS [Line Type],
 @2 AS [Line Description]
From etc etc....

Don't forget the semicolon before the second Load statement.

Help with my Script

hopkinsc — Fri, 06 Aug 2010 12:20:00 GMT

Excellent, thanks. I used your first suggestion, it has worked now.

Thanks for your help