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

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 )