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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-11-17 09:55 AM

how do we analyze 1 to many relationship between tables

Hi,

Can anyone please suggest with some example as what does 1 to many relationship means and how should we handle in qlikview data model.

657 Views
0 Likes
3 Replies
Anonymous
Not applicable
‎2014-11-17 10:43 AM
Author

Hi Sri,

      The typical ex for One to Many is Mother---> Kids. One mother can have many kids. But kid can have only one Mother. Beyond this the analysis can tell once you shared your requirement or KPIs.

-Jay

410 Views
0 Likes
Not applicable
‎2014-11-17 08:31 PM
Author

In response to Anonymous

HI Jay,

Can you please explain me how do we handle this type of data in qlikview.

410 Views
0 Likes
Anonymous
Not applicable
‎2014-11-18 02:47 AM
Author

In response to

Hi Sri,

    The QlikView itself will help you to analyze the data. In order to create reports have a look the table and the data. As QlikView will create auto link between the table you may need to make sure the key fields. And if required you can use Distinct key words, when ever it required.
All above this it would be easy for us, if you share kind of KPIs and Table info

-Jay

410 Views
0 Likes