Qlik Community

Ask a Question

New to QlikView

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

many to many mapping

Hi ,

I'm having a scenario to deal with many to many.

Attched is the sample data.

I need to plot # sites at each location.

I can't explain more beacure It may confuse.

By seeing data you can understand.

Thanks..

Labels (1)
5 Replies
Employee
Employee

There is not a good relationship in the data. Country is the only thing in common and the data doesn't match up.

eg AUSTRALIA 

Lisa_P_0-1597190560909.png

 

PHILIPPINES

Lisa_P_1-1597190698246.png

 

Contributor II
Contributor II

Hi,

 

Please find the attached revised data.

I need bring site ID to the dimension sheet to get event type for site ID's.

 

Please help me I'm out of Ideas.

 

Thanks...

Employee
Employee

I cannot see the relationship between these tables to do that

Digital Support
Digital Support

Try reviewing the following Help link, you may be able to find what you need there to figure out how you need to proceed here:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Loading_data.ht...

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.
MVP
MVP

try using combination of both country and location. But seems like there are lot many mismatches.

Map_site:
mapping LOAD Distinct lower(trim(Country))&lower(trim(Location)) as Key,
[Site ID]
FROM
[Book1.xlsx]
(ooxml, embedded labels, table is [SIte ID]);

 

Data:
LOAD country,
location,
//lower(trim(country))&lower(trim(location)) as Key2,
applymap('Map_site',lower(trim(country))&lower(trim(location)),'NA') as [Site ID],
latitude,
longitude,
event_type
FROM
[Book1.xlsx]
(ooxml, embedded labels, table is DImension);