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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with FIELDVALUE() function

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

1 Reply
erichshiino
Partner - Master
Partner - Master

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 )