Set variable as seperator

Thu, 13 Jun 2013 14:24:45 GMT

Hi all - This one is bugging me but I know one of you experts will get it straight away!

I am concatenating two fields together into one new field in my load script, such as Company Code and Company Name. i.e.

CompCode & '-' & CompCodeDesc as CompKeyandTxt

Which gives the user the user the key and text in one field seperated by -

What I want to do is have a variable on the main tab which defines what character the seperator is so that I only need to change it once if the users decide they want a comma or space or anything else as the seperator.

I've tried:-

set vSeperator = '-';

CompCode & $(vSeperator) & CompCodeDesc as CompKeyandTxt

and numurous other variations without success.

Can anyone help?

Many thanks in advance.

Sean.

Re: Set variable as seperator

Thu, 13 Jun 2013 14:28:48 GMT

load X & '$(vSeperator)' & Y AS TEST

You forget the quotes !

Re: Set variable as seperator

Anonymous — Thu, 13 Jun 2013 14:30:31 GMT

Sean,

Try this:
let vSeperator = chr(39) & '-' & chr(39);

Regards,
Michael

Edit: I changes set to let

Re: Set variable as seperator

Thu, 13 Jun 2013 14:34:03 GMT

Excellent! Thanks both!

topic Re: Set variable as seperator in QlikView

Set variable as seperator

Re: Set variable as seperator

Re: Set variable as seperator

Re: Set variable as seperator