Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with FIELDVALUE() function

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

3 Replies
Not applicable
Author

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.


Not applicable
Author

Thanks!!!

I was having the same question/problem. 

sivarajs
Specialist II
Specialist II

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.