topic Re: Create variable from data fields in QlikView

Create variable from data fields

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

Hi,

Please help me how to create variables from existing data in QlikView. I wish to have a list of value for 'ReportMth' = Rep.

DATA:

NoConcatenate

LOAD Distinct * Inline [

Rep

01/04/2017

02/06/2017

];

let ReportMth = FieldValue(Rep,DATA);

Re: Create variable from data fields

Anil_Babu_Samineni — Wed, 26 Apr 2017 04:04:47 GMT

Which value you want to set as variable. May be this?

LET ReportMth = FieldValue(Rep,1); //This will return firstvalue from Rep field

Re: Create variable from data fields

mohdhaniff — Wed, 26 Apr 2017 04:10:29 GMT

Hi Anil,

I am getting blank result...

Re: Create variable from data fields

Anil_Babu_Samineni — Wed, 26 Apr 2017 04:14:17 GMT

May be this

LET a = FieldValue('Rep',1); // I've added single colon. Check in Ctrl + Alt + V environment

Re: Create variable from data fields

mohdhaniff — Wed, 26 Apr 2017 04:45:01 GMT

Thanks Anil. Its work as my wish.

As additional, can you recommend me how to get all value in Rep listed into ReportMth

Re: Create variable from data fields

Anil_Babu_Samineni — Wed, 26 Apr 2017 05:14:11 GMT

May be this?

DATA:

NoConcatenate

LOAD Distinct * Inline [

Rep

01/04/2017

02/06/2017

];

//Script

LET noRows = NoOfRows('DATA')-1;

FOR i=0 to $(noRows)

LET vVar=FieldValue('Rep',$(i));

LOAD *, '$(vVar)' as ReportMth

Resident DATA;

Next i;

Or Simple do this

DATA:

NoConcatenate

LOAD Distinct Rep, Rep as ReportMth Inline [

Rep

01/04/2017

02/06/2017

];

Re: Create variable from data fields

mohdhaniff — Thu, 27 Apr 2017 00:54:44 GMT

Thanks Anil..