Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Think about SENS as a completely independent field.
QlikView will know only the values C and D.
So, you can get only values 1 (C) and 2 (D)
To get what you need you could try to use only( FIELD):
=only( {<ID={1}>} SENS )