Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
electra
Contributor
Contributor

Qlik Sense how to filter keys in load editor from the keys of another table

Hi there,

I would like to filter the rows of table F_SPRINT in order to include only the rows where the 'issue key' is in the AUGUST table:

I am trying to do something like this in SQL:

select *

from F_SPRINT

where issue_key in (select issue_key from August_table)

In QS this is what I wrote but it doesnt work, I am not sure what is the right code:

F_SPRINT:
LOAD
*
FROM F_SPRINT
WHERE [Issue Key] in (
LOAD [Issue Key]
FROM ISSUE_KEYS_AUGUST_2022
)

Could you please help me?

Thanks so much,

Electra

Labels (2)
1 Reply
Mark_Winter
Creator
Creator

You can use exists for this