Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Many to many relationship between Fact & Dimension

Hello Qlikview Experts

Join between Fact and Dimension tables has many-to-many relation. "Flag" is the column used to join fact & dimension table

Dimension                            

ShowFlagFlag
A&BA
A&BB
A&CA
A&CC

FACT

DateFlagMeasure1
Jan2014A100
Jan2014B200
Jan2014C300
Feb2014A150
Feb2014C50
Mar2014A20
Mar2014B30

Users wanted to see the aggregate of A&B or A&C. "ShowFlag" is displayed as a listbox with "always 1 selected value" constraint enabled. Aggregation happens correctly based on the selection.

A DW/BI expert commented that this data model will duplicate rows in memory when the application is opened.

Is this true? Will Qlikview duplicate rows and create a Cartesian product in memory?

Thanks

0 Replies