topic Cardinalities in a database in QlikView https://community.qlik.com/t5/QlikView/Cardinalities-in-a-database/m-p/342792#M126601 <HTML><HEAD></HEAD><BODY><P>How does qlikview identify the cardinality of a relationship? Does it behaves differently for different cardinalities?</P></BODY></HTML> Tue, 10 Jul 2012 08:38:52 GMT 2012-07-10T08:38:52Z Cardinalities in a database https://community.qlik.com/t5/QlikView/Cardinalities-in-a-database/m-p/342792#M126601 <HTML><HEAD></HEAD><BODY><P>How does qlikview identify the cardinality of a relationship? Does it behaves differently for different cardinalities?</P></BODY></HTML> Tue, 10 Jul 2012 08:38:52 GMT https://community.qlik.com/t5/QlikView/Cardinalities-in-a-database/m-p/342792#M126601 2012-07-10T08:38:52Z Re: Cardinalities in a database https://community.qlik.com/t5/QlikView/Cardinalities-in-a-database/m-p/342793#M126602 <HTML><HEAD></HEAD><BODY><P>In principle, QlikView does not care about cardinality. Whether a link between two tables is a many-to-one or many-to-many relationship is irrelevant to QlikView. QlikView works the same way in both cases.</P><P></P><P>But having said that, there is a place where where it does matter: When showing frequency for keys in List boxes. Then QlikView tries to identify a table as the one where the key is a foreign key so that this table can be used to calculate the frequency.</P><P></P><P>HIC</P></BODY></HTML> Tue, 10 Jul 2012 16:33:37 GMT https://community.qlik.com/t5/QlikView/Cardinalities-in-a-database/m-p/342793#M126602 hic 2012-07-10T16:33:37Z Re: Cardinalities in a database https://community.qlik.com/t5/QlikView/Cardinalities-in-a-database/m-p/342794#M126603 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hi HIC,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Is there any documentation of architecture? I wanted more understanding on Memory calculation &amp; storage capacity.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Thanks,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">DV</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">www.QlikShare.com<BR /></SPAN></P></BODY></HTML> Sat, 14 Jul 2012 10:57:25 GMT https://community.qlik.com/t5/QlikView/Cardinalities-in-a-database/m-p/342794#M126603 IAMDV 2012-07-14T10:57:25Z Re: Cardinalities in a database https://community.qlik.com/t5/QlikView/Cardinalities-in-a-database/m-p/342795#M126604 <HTML><HEAD></HEAD><BODY><P>See more on <A class="loading" href="http://www.dbms2.com/2010/06/12/the-underlying-technology-of-qlikview/">http://www.dbms2.com/2010/06/12/the-underlying-technology-of-qlikview/</A></P><P></P><P>About memory calculation: it is not just difficult - it is impossible. </P><P>1: The data model takes place. Proportional to number of rows x column in data table,</P><P>2: Symbol tables take place. Proportional to number of fields and number of field values (cardinality)</P><P>3: Every chart takes place. Proportional to cardinality in Dim1 x cardinality in Dim2 x cardinality in Dim3 etc, Further, if the calculation implies fields from several data tables, even more memory is needed.</P><P></P><P>Bottom line: Make test application and extrapolate.</P><P></P><P>HIC</P></BODY></HTML> Thu, 19 Jul 2012 11:51:31 GMT https://community.qlik.com/t5/QlikView/Cardinalities-in-a-database/m-p/342795#M126604 hic 2012-07-19T11:51:31Z Re: Cardinalities in a database https://community.qlik.com/t5/QlikView/Cardinalities-in-a-database/m-p/342796#M126605 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Thank you HIC. Very helpful.</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Cheers - DV</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;"><A href="http://QlikShare.com">http://QlikShare.com</A></SPAN></P></BODY></HTML> Thu, 19 Jul 2012 13:50:31 GMT https://community.qlik.com/t5/QlikView/Cardinalities-in-a-database/m-p/342796#M126605 IAMDV 2012-07-19T13:50:31Z Re: Cardinalities in a database https://community.qlik.com/t5/QlikView/Cardinalities-in-a-database/m-p/342797#M126606 <HTML><HEAD></HEAD><BODY><P>You can get details on RAM requirements for a qvw by creating a mem file (Doc Properties, General pane). Load the mem file with QV Optimizer for analysis.</P><P></P><P><SPAN>You can also get memory data by using DocumentAnalyzer </SPAN><A class="jive-link-external-small" href="http://robwunderlich.com/downloads">http://robwunderlich.com/downloads</A></P><P>DocAnalyzer also uses a mem file, but it creates it on the fly.</P><P></P><P>Neither of these techniques idendify the memory required for calculation, but they do give a good understanding of the RAM required for data storage and chart definitions. </P><P></P><P>-Rob</P></BODY></HTML> Thu, 19 Jul 2012 14:32:33 GMT https://community.qlik.com/t5/QlikView/Cardinalities-in-a-database/m-p/342797#M126606 rwunderlich 2012-07-19T14:32:33Z Re: Cardinalities in a database https://community.qlik.com/t5/QlikView/Cardinalities-in-a-database/m-p/342798#M126607 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Thank you Rob.</SPAN></P></BODY></HTML> Sun, 22 Jul 2012 09:07:10 GMT https://community.qlik.com/t5/QlikView/Cardinalities-in-a-database/m-p/342798#M126607 IAMDV 2012-07-22T09:07:10Z