topic Re: Function FieldValue without the distinct values in QlikView

Function FieldValue without the distinct values

richters — Thu, 14 Feb 2013 11:26:59 GMT

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!

Re: Function FieldValue without the distinct values

Gysbert_Wassenaar — Thu, 14 Feb 2013 11:31:29 GMT

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

Re: Function FieldValue without the distinct values

richters — Thu, 14 Feb 2013 11:41:26 GMT

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

Re: Function FieldValue without the distinct values

Tue, 23 Apr 2013 21:32:34 GMT

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

Thanks

Re: Function FieldValue without the distinct values

Anonymous — Thu, 03 Apr 2014 17:29:35 GMT

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.

Re: Function FieldValue without the distinct values

marinasbc — Tue, 13 Jan 2015 12:54:17 GMT

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