Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

excel vlookup functionality in Qlik sense

Hi.  I have two data elements in a loaded table that if in excel I would have concatenated into a new column in the table and then added an additional column to flag a criteria.

Element 1 = TaskID (multiple records in the table)

Element 2 = Type (can be multiple values per TaskID)

Added Element 3 = TaskID&Type

Desired Element 4 = flag as Y/N if the record has the a matching Element3 in the table with the record's TaskID& a text string Type as  manually selected

Any suggestions on how to create data load editor?  Thanks!