Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Partner
Partner

search in table rows

Hello,

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)

 

many thanks

Noel

4 Replies
Highlighted
Partner
Partner

Re: search in table rows

Hi,

try with firstvalue() or firstsortedvalue()

Highlighted
MVP
MVP

Re: search in table rows

>> the first row that matches...

"First"' in terms of what? Load order, date order or some other order?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Partner
Partner

Re: search in table rows

Lets say that i have load the following table...

LOAD employee_code, nationality;

and the rows that the table has are:

1,GRC

2,GRC

3,GRC

4,GRC

5,GRC

6,GRC

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.

Best Regards

 

Highlighted
Partner
Partner

Re: search in table rows

any ideas ?