topic Re: assign field values into a variable in QlikView

assign field values into a variable

Mon, 05 Nov 2012 10:20:23 GMT

Hi all,

Can we place in a variable with the field of distinct values in edit script load ?

Ex: Consider the in my table having FieldA and having values in it are 5

FieldA

Now i needs to have my variable vVar1 = 1,2,3,4

Thanks in advance.

Re: assign field values into a variable

sivarajs — Mon, 05 Nov 2012 10:32:34 GMT

Try this

set vVar='Fieldname';

Concat($(vVar),',')

Re: assign field values into a variable

Mon, 05 Nov 2012 10:41:19 GMT

Hi Sivaraj, thanks for your response. But concat function will not work in edit script.

Below scritp what i'm trying in my original project

If(vStep = 0) then

//Initial Load

Tab1:

LOAD CaptureDateTime

FROM

[..\QVD\4Weeks\EAT_20121029.qvd]

(qvd);

Let vVar = CaptureDateTiem;

ELSE

//Incremental Load

Tab1:

LOAD CaptureDateTime

FROM

[..\QVD\4Weeks\EAT_20121029.qvd]

(qvd) Where not Exists($(vVar));

ENDIF

I hope you might got what i'm looking for ?

Thanks in advance.

Re: assign field values into a variable

sivarajs — Mon, 05 Nov 2012 10:53:24 GMT

Concat works in script,am little confused with your script logic

Re: assign field values into a variable

Mon, 05 Nov 2012 11:30:43 GMT

Sorry,Yes Concat function is working in Edit Script.

I tried below script but not holding any values in vVar variable, just displays empty in vVar.

Tab1:

LOAD * Inline

[CaptureDateTime

3];

let noRows = NoOfRows('Tab1')-1;

for i=0 to $(noRows)

let vVar =Concat(peek('CaptureDateTime',$(i),'Tab1'),',');

Please let me know what is the wrong in this.

Thanks in advance

Re: assign field values into a variable

sivarajs — Mon, 05 Nov 2012 11:57:14 GMT

Use this

Tab1:

LOAD * Inline [

CaptureDateTime

5];

let noRows = NoOfRows('Tab1')-1;

for i=0 to $(noRows)

let vVar=FieldValue('CaptureDateTime',$(i));

LOAD * ,'$(vVar)' as Field1

Resident Tab1;

next i

In where clause use Field1 instead of variable

This might help for you

Re: assign field values into a variable

Mon, 05 Nov 2012 12:50:19 GMT

Hi,

Please have a look at the Qlikview Components:

http://code.google.com/p/qlikview-components/

Especially Qvc.PopulateVariables

That will do all of the above, but then a lot cleaner.

Kind Regards,

Dion

Re: assign field values into a variable

jeffmartins — Mon, 05 Nov 2012 19:21:23 GMT

Hi venkatveer,

you can solve this using the concat function with a temporary table and then the peek function to assign the field value to the vVar1 variable.

See the attached file.

Regards

Re: assign field values into a variable

michaelfreitas — Thu, 28 Jan 2016 16:48:23 GMT

Jefferson Martins correctly answered your question.

Adding:

In the stretch :let vVar1 = peek ( ' FIELDA ', 0 , ' tmp ');

..if the name FIELDA field is with space, [ Field A] inform without symbols [ ] , example :

let vVar1 = peek ( 'Field A', 0 , ' tmp ');