Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

For each - get a second value associated

Hi everybody,

I have the following code. I would like to get the value of ce.archive in my For Loop.

How do I do that ?

CONCATENATE(filesToLoad)

load * inline

[

ce.archive, ce.fileList

'N', cpm.xlsm'

'O', 'ghdfsfds.xlsm'

'O', 'skfds.xlsm'

'N', 'liac.xlsm'

]

;

For Each nomfic in FieldValueList('ce.fileList')

Tags (1)
6 Replies
Highlighted
MVP
MVP

Re: For each - get a second value associated

Have you tried like?

For Each nomfic in FieldValueList('ce.fileList')

    <your statement>

Next nomfic;

Highlighted
Creator
Creator

Re: For each - get a second value associated

Hi Tresesco,

Yes. I've got the whole loop already. What I want, is get the first value of the inline table ce.archive in the loop.

Highlighted
Master III
Master III

Re: For each - get a second value associated

may be just

Let xx=Peek('ce.archive',0,'T1');

Highlighted
Master III
Master III

Re: For each - get a second value associated

or Let xy=FieldValue('ce.archive',1);

Highlighted
Master III
Master III

Re: For each - get a second value associated

for each vField in FieldValueList('ce.fileList')

Let xx1='$(vField)';

Next;

Highlighted
Creator
Creator

Re: For each - get a second value associated

Thanks Sasidhar, the second formula did not work, I got only null in my variable, but the first one was ok!

Have a good day!