topic Re. :Problem with FIELDVALUE() function in QlikView

Problem with FIELDVALUE() function

Tue, 12 Apr 2011 09:25:07 GMT

Hello community

I have a table in my Qlikview application.

I want to access information in the column SENS.

I use the formula = FieldValue ('', )

I have done : FieldValue ('SENS', 1), the result is 'D', which is correct.
I have done : FieldValue ('SENS', 2), the result is'C', which is still okay.

But when I use the values ??between 3 ,.. 10, no result is displayed, I do not know why?

That is to say: FieldValue ('SENS', 3), no results are displayed,

Similarly for the values ?? 4, 5, ... , 10

What should I do?

Please look at the attached file for more details

Thanks

Re. :Problem with FIELDVALUE() function

Tue, 12 Apr 2011 17:31:22 GMT

Good afternoon community.

Just to inform you that I found the solution to my problem.

In fact he had to use the PEEK function () instead function FieldValue () why?

In fact, according FieldValue () ignores values ??that are repeated, including definition of a whole does not repeat values.

While the PEEK function () does not hold the values ??that are repeated.

Thank you.

Re: Re. :Problem with FIELDVALUE() function

Mon, 15 Jul 2013 21:27:25 GMT

Thanks!!!

I was having the same question/problem.

Re: Re. :Problem with FIELDVALUE() function

sivarajs — Tue, 16 Jul 2013 06:25:19 GMT

Qlikview stores repeated values as distinct i.e It stores in single loaction and refer like pointers

By looking at your values C,D are stored once,It holds 1 and 2 position(take field SENS in listbox).So Field value works based on loaction of string.Since you have only two positions you dont get value after 3.