Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
happyfeet11
Contributor III
Contributor III

join, mapping or is there a better way to reduce data load in qliksense

Dear All,

 I am trying to understand the following and would urgently need your help:

 

I have a query with data extracted from two table with where conditions which i have generated in SQL and now need to adapt to Qliksense script. it generated about 500 datapoints.

how can i extract the same  filtered data from  the two tables   which has a primary key common to both tables and avoid  loading all the data?

 

i have tried resident ::: didnt work ? dont know what i was doing wrong?

i have tried mapping : again dont know what was wrong.

most imporatnt thing is i am new to qliksense 🙂

 

I look forward to your help.

thanking you

Regards

Indrani

 

Labels (1)
1 Reply
y_grynechko
Creator III
Creator III

Good Morning, 

mapping load is a good approach here.

Before you load the tables create mapping like this:

NameOfMapping:
Mapping Load
ID,
FieldYouWantToMapToID
FROM [lib://TableYouWantToSourceMappingFrom](qvd);

 

After that when you load the table you want to filter by mapping use something like this:

TableName:

LOAD
ID,

SomeField,

SomeField2
FROM [lib://OtherTableWithSameIDAsMapping](qvd)
where
ApplyMap('NameOfMapping', ID, null()) = 'SomeFilterValue';