Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

richters
New Contributor III

Function FieldValue without the distinct values

Hi all,

I am using the FieldValue- function to set my variables with a specific data row of a table (loop through the table). The problem is that the function takes distinct values of the column in the table which means that if a value is twice in there, the second one will be missed out.

Is there a function that gives me the value of row x in the table?

What I try to do is :   Let valueX = FieldValue('MyField',$(rownumber));

Thank you!

1 Solution

Accepted Solutions

Re: Function FieldValue without the distinct values

You can use peek and specify a row number: peek('MyField', $(rownumber),'MyTable')


talk is cheap, supply exceeds demand
5 Replies

Re: Function FieldValue without the distinct values

You can use peek and specify a row number: peek('MyField', $(rownumber),'MyTable')


talk is cheap, supply exceeds demand
richters
New Contributor III

Re: Function FieldValue without the distinct values

Thank you, great. Didn't know that peek() works out of a load-statement. Thank you very much!

Not applicable

Re: Function FieldValue without the distinct values

it doesn't work when I call peek function in a text object properties..... what can I do?

Thanks

K

jcooney1
New Contributor III

Re: Function FieldValue without the distinct values

I wish I read this about 2 hours ago!!

Exactly what is the purpose of the Fieldvalue function to begin with is my question.?? 

I made the mistake of copying somebody else's example using Fieldvalue and went on a wild goose chase until I discovered it was omitting repeat values.

marinasbc
New Contributor III

Re: Function FieldValue without the distinct values

Hi Gysbert,

And if you need to use this on the front-end, do you have any ideas how to?

Thank you,

Best Regards,

Marina

Community Browser