Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Thanks!!!
I was having the same question/problem.
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.