topic Re: Expression needed in QlikView

Expression needed

Fri, 26 Sep 2014 16:18:03 GMT

Hi,

I have table as below and 4 variables. Need expression for below..

LOAD * INLINE [

IId, Des

2, Two

3, Three

5, Five

7, Seven

10, Ten

];

I need first record of the table Des into Var1.

Second record of the Des into Var2 and so on..

Fri, 26 Sep 2014 16:28:02 GMT

Try something like below

LET variable1 = PEEK('Des',0,'Demo');

LET variable2 = PEEK('Des',1,'Demo');

LET variable3 = PEEK('Des',2,'Demo');

LET variable4 = PEEK('Des',3,'Demo');

simondachstr — Fri, 26 Sep 2014 16:32:22 GMT

for i=1 to FieldValueCount('Ild')

Let $('Var'&i) = peek('Des',$(i))

NEXT i

Fri, 26 Sep 2014 17:06:50 GMT

Hi Martin,

Thanks. It is working.

Fri, 26 Sep 2014 17:09:46 GMT

Hi Kiruthi,

Thanks it is working.