Create variable from data fields

[mohdhaniff]

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);

[Anil_Babu_Samineni]

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

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

[mohdhaniff]

Hi Anil,

I am getting blank result...

[Anil_Babu_Samineni · Accepted solution]

May be this

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

[mohdhaniff]

Thanks Anil. Its work as my wish.

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

[Anil_Babu_Samineni]

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

];

[mohdhaniff]

Thanks Anil..