Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider - Maximize your investment, Join this webinar, May 26th. Register Today
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