Discussion board where members can learn more about Qlik Sense App Development and Usage.
I want to search in table rows with the following expression and return to me the first row that matches
example: employee_code=5 and nationality='GRC'
I have already loaded a table, I don't want to run a select/where statement at load time, I need to process the rows afterwards (hint: lookup cannot take expressions)
try with firstvalue() or firstsortedvalue()
>> the first row that matches...
"First"' in terms of what? Load order, date order or some other order?
Lets say that i have load the following table...
LOAD employee_code, nationality;
and the rows that the table has are:
i want somehow to apply the following expression "employee_code=5 and nationality='GRC'" and return to me the first row that matches in this example is fifth row.
any ideas ?