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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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