Filter out data in the data editor

[DWolsie]

Hello everyone,

I'm trying to filter data in the data editor such that only one value is picked. Right now I'm using it like this:

However, Qlik Sense still loads all other relevant data. Only when I click on the only option does it filter for just this data.

How can I use the data editor, such that I immediately see only the data such as in the last image? Thanks in advance!

[Qrishna]

Not sure what exctly is going on in your script but you could try below too>:

Load *
where AUFNR = '170...' ;
Load field1,
Field2,
...
from your_source;

[DWolsie]

Hi @Qrishna, unfortunately this hasn't helped. I've attached my script below, as wall as the master elements I'm using.

[lennart_mo · Accepted solution]

Hi @DWolsie,

Seeing your Script the problem is that your loading the other tables completely  and not limited on the OBJNRs present for the selected AUFNR. So in the end you still have all the data from your other two tables, they just don't have a corresponding AUFNR for most of the records.

So i would suggest you load the table [AUFK] first and add 'Where Exists(OBJNR)' to the end of the other two LOAD-Statements.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordFun...

[DWolsie]

Thank you so much, it now works the way I want to!