Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor

Synthetic key

I have a requirement of filtering two tables with two common fields. If I concatenate fields i wont get fields available to be put in filter pane separately. Suppose Table 1  has  date,name,marks,DOB,birthmark,country and Table2 has date,country,address,zone and state  as fields. date  and country  are to be put as common filters for both tables. Help is appreciated.

Labels (2)
3 Replies
Highlighted
Partner
Partner

Re: Synthetic key

Hi,

TABLE1:
LOAD
date&'-'&country            AS DATE_COUNTRY_KEY,
date,
name,
marks,
DOB,
birthmark,
country
FROM TABLE1;

TABLE2:
LOAD
date&'-'&country               AS DATE_COUNTRY_KEY,
address,
zone,
state
FROM TABLE2;

Highlighted
New Contributor

Re: Synthetic key

Hi! First of all,Thank you for your efforts. Could you help me with filter pane too. If i make the composite key like you have demonstrated, I don't find any way how i can put both fields as common filter.

 

 

Highlighted
Digital Support
Digital Support

Re: Synthetic key

Saksham, have a look at the following Design Blog posts, I think it may help explain things and potentially help you with getting what you want in your data model.  There are hundreds of other posts in this area as well, so I will also include the base URL for you, so you can further search for other posts if you like.  

In this case, I would think it may be better to join the tables into a single table, but I am sure you have reason for keeping them separate, more info on the use case may help on this one...

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

https://community.qlik.com/t5/Qlik-Design-Blog/To-Join-or-not-to-Join/ba-p/1463102

https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-join-use-Applymap-instead/ba-p/1467592

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.