topic Re: LET statement to extract text variable in QlikView

LET statement to extract text variable

jayabedin — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am using LET statement to store some text values in script. I have used the syntax

LET vField1 = $(Field1);

when displaying values using

=$(vField1) getting a minus(-) sign.

Your early response will be highly appreciated.

Regards

Jay.

Re: LET statement to extract text variable

vishsaggi — Wed, 20 Dec 2017 03:14:04 GMT

What is this Field1? IS this a variable or a field from a table?

To store text values i Use set rather than Let.

Can you share some sample values?

Oh hold on does the Field1 has multiple values if yes you might want to use Concat() function to get multiple values.

Re: LET statement to extract text variable

sushil353 — Wed, 20 Dec 2017 03:15:07 GMT

Hi Jaynal,

is the Field1 is field of a table or a variable earlier calculated in the script ?

if Field1 is a field of a table then u can use following code

Temp:

Load Field1 from table X;

LET vField1 = peek('Field1',0,'Temp');

HTH

Sushil

Re: LET statement to extract text variable

jayabedin — Wed, 20 Dec 2017 03:23:44 GMT

Hi Sushil,

Field1 is a field in a table with multiple values.

If I understood you correctly the syntax peek will extract value 0 and Temp from Field1.

Thank you very much. i will give it a go.

Re: LET statement to extract text variable

jayabedin — Wed, 20 Dec 2017 03:40:18 GMT

Hi Vishwarath,

Thank you very much for the quick response.

Field1 is a field in a table.

what would the syntax for SET statement?

SET vPriority_Code1 = $('PriorityMap.Priority_Code');

Is the syntax correct?

Re: LET statement to extract text variable

jayabedin — Wed, 20 Dec 2017 03:45:05 GMT

Hi Sushil,

Looks like there is issue with my syntax below.

LET vPriority_Code2 = peek('PrioirityMap.Priority_Code','P1','P2');

Re: LET statement to extract text variable

sushil353 — Wed, 20 Dec 2017 03:48:57 GMT

Hi Jaynal,

what is P1 and P2 ?

Peek function will fetch a field records from a table based on the index values of the record.

General syntax is Peek('FieldName',indexvalue,'TableName')

HTH

Sushil

Re: LET statement to extract text variable

sushil353 — Wed, 20 Dec 2017 03:49:28 GMT

Index value should be a number without quote sign

Re: LET statement to extract text variable

vishsaggi — Wed, 20 Dec 2017 04:15:52 GMT

Are you looking for Multiple values or one single value from your text field?

When you say $(PriorityMap.Priority_Code) is this a variable or Field name from your Load script.

If PriorityMap.Priority_Code is your Field name you should try

SET vPriority_Code = 'PriorityMap.Priority_Code';

Then use like in your textbox

= $(vPriority_Code)

If you have multiple values you might want to add a temp table like below:

Temp:

LOAD Concat(DISTINCT PriorityMap.Priority_Code, '|') AS StringValue

Resident YoursourceTablename;

SET vString = 'PriorityMap.Priority_Code';

SET vPriority_Code = 'StringValue';

= $(vPriority_Code)

Re: LET statement to extract text variable

uacg0009 — Wed, 20 Dec 2017 09:13:46 GMT

HI Jaynal,

I think because the Field1 is a field, so it will have more than 1 value in it, so the variable can not show all the values using that method.

I think you need to use concat funciton like:

set vtest = =Concat(DISTINCT Field1,',');

Thanks.

Aiolos

Re: LET statement to extract text variable

jayabedin — Wed, 20 Dec 2017 22:07:16 GMT

Hi Aiolos,

Thank you very much. You are absolutely right. Field1 is a field in a table that has multiple values.

I will follow this syntax. This looks nice and easy.

Regards

Jay.