Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
DiaEli1980
Contributor II
Contributor II

FieldValue problem

Hello

I have a trouble with my app, I have some tables that are loading to excel files, I need to put an especific value in a KPI control it shoul change when I select a diferent date.

The problem is that fieldvalue function only accept strings, I need link a variable that function.

I am using the following formula:

if($(MesFiltro)='abr*',FieldValue('% CUMPLIMIENTO SD',RowNo()),'no funciona')

Maybe someone know any function to seach in a table like vlookup in excel.

 

 

 

 

1 Reply
vikramv
Creator III
Creator III

Hi ,

There are many other ways to do this like LookUp , Peek etc... 

In your case,Peek would be the easiest way.

Try replacing Field Value with Peek.

 

Thanks.

Vikky