Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
richters
Partner - Contributor III
Partner - 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
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
richters
Partner - Contributor III
Partner - Contributor III
Author

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

Not applicable

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

Thanks

K

Anonymous
Not applicable

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
Partner - Contributor III
Partner - Contributor III

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