topic Re: field values assign variable in QlikView

field values assign variable

Wed, 28 May 2014 04:38:44 GMT

Hi,

i have loaded a table into my script

LOAD VariableName,

VariableValue,

VariableType,

VariableFormat

FROM

(ooxml, embedded labels, table is [Color Settings]);

i Need to create variable with these field names.

can somebody please help me

Re: field values assign variable

Wed, 28 May 2014 04:44:14 GMT

If your Table Name is Tab:

Tab:

LOAD

VariableName,

VariableValue,

VariableType,

VariableFormat

FROM

(ooxml, embedded labels, table is [Color Settings]);

Let VariableName= peek('VariableName',0,'Tab');

Let VariableValue= peek('VariableValue',0,'Tab');

Let VariableType= peek('VariableType',0,'Tab');

Let VariableFormat= peek('VariableFormat',0,'Tab');

Add that in a for loop if you have more than 1 Color.

Re: field values assign variable

amit_saini — Wed, 28 May 2014 04:45:30 GMT

Hi,

Do you mean to create variables by using fields VariableName ,VariableValue and so on....?????

Thanks,
AS

Re: field values assign variable

Wed, 28 May 2014 04:48:19 GMT

Hi Amit saini,

Yes i need to create variables by using fields VariableName ,VariableValue and so on...

Re: field values assign variable

amit_saini — Wed, 28 May 2014 05:01:12 GMT

Hi,

You can do like this (Press CTRL + ALT +V and set the value of variables, they way i did for vV1 ,vV2 and so on) or follow Eva POLINI suggestion also, both will work:

Thanks,

Re: field values assign variable

Wed, 28 May 2014 05:05:39 GMT

It you run my script, you will have 4 variables : VariableName, VariableValue, VariableType, VariableFormat.

Re: field values assign variable

amit_saini — Wed, 28 May 2014 05:08:39 GMT

Eva,

I know this will also work, I suggested him one more way of assigning values to different variables.

Thanks,
AS

Re: field values assign variable

Wed, 28 May 2014 05:11:22 GMT

Sorry, my bad !! I read to fast... for any reason, I read "do both in the same time...."

Re: field values assign variable

Wed, 28 May 2014 05:13:49 GMT

Hi I created the variable but i am not getting the data.

Re: field values assign variable

amit_saini — Wed, 28 May 2014 05:14:22 GMT

No Problem !

Cheers,

Re: field values assign variable

amit_saini — Wed, 28 May 2014 05:15:08 GMT

Could you please share you application.

Thanks,

Re: field values assign variable

Wed, 28 May 2014 05:26:29 GMT

I can not find the attachment symbol to attach Application

Re: field values assign variable

amit_saini — Wed, 28 May 2014 05:31:04 GMT

Hi ,

See below at the top there is a option right top side "Use Advanced editor" click this and you will be having attachment option.

Thanks,
AS

Re: field values assign variable

Wed, 28 May 2014 05:33:41 GMT

have you got a table "Tab" with values in?

Re: Re: field values assign variable

Wed, 28 May 2014 05:38:22 GMT

Hi i attached the value in the table please give me solution how can i get those values using variable

Re: Re: Re: field values assign variable

Wed, 28 May 2014 05:49:00 GMT

I add the let statement, it's just to be able to set the variable in the script.

For the interface: =If(Count(VariableName)=1,VariableName)

Re: Re: Re: field values assign variable

Wed, 28 May 2014 06:02:02 GMT

That is fine but if i use the variable in charts & text boxes the data is not coming

Re: Re: Re: Re: field values assign variable

Wed, 28 May 2014 06:08:31 GMT

What's about that?

Re: field values assign variable

Wed, 28 May 2014 06:08:34 GMT

Hi, Need help

Try something like this:

test:

LOAD *,RowNo() as ID

Resident [Color Settings];

DROP Table [Color Settings];

tempRowsNum:

First 1 LOAD ID as RowsNum

Resident test

Order By ID desc;

LET vRowsNum = Peek('RowsNum',0,'tempRowsNum');

DROP Table tempRowsNum;

FOR vRow = 1 to $(vRowsNum)

LET vName = Peek('VariableName',$(vRow),'test');

LET vExpr = Peek('VariableValue',$(vRow),'test');

SET $(vName) = $(vExpr);

NEXT vRow;

Re: field values assign variable

amit_saini — Wed, 28 May 2014 06:10:38 GMT

Hi ,

I'm not sure what you are trying to achieve here , you already having filed which you can use in your calculation. I 'm not sure if this is possible which you are trying to do by using variables here.

Thanks,