If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.
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.