topic Re: Hierarchical facts in QlikView https://community.qlik.com/t5/QlikView/Hierarchical-facts/m-p/1304718#M406229 <HTML><HEAD></HEAD><BODY><P>Can you explain more about the problem.</P><P>A file with data is beter.</P></BODY></HTML> Sat, 20 May 2017 18:45:23 GMT ecolomer 2017-05-20T18:45:23Z Hierarchical facts https://community.qlik.com/t5/QlikView/Hierarchical-facts/m-p/1304717#M406228 <HTML><HEAD></HEAD><BODY><P>I have tables A, U and E</P><P>A can have 0 or more U</P><P>U can have 0 or more E</P><P>Facts exist for both A and U</P><P>Dimensions exist for A,U and E</P><P></P><P>For example, the concatenated table for A(1,2), U(21,22,23) and E(211,212) would look like</P><TABLE border="1" class="jiveBorder" height="50" style="border: 1px solid rgb(0, 0, 0); width: 291px; height: 23px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">%A</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>AF</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>%U</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>UF</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>%E<BR /></STRONG></TH></TR><TR><TD>1</TD><TD>100</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>2</TD><TD>90</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>2</TD><TD></TD><TD>21</TD><TD>10</TD><TD></TD></TR><TR><TD>2</TD><TD></TD><TD>22</TD><TD>15</TD><TD></TD></TR><TR><TD>2</TD><TD></TD><TD>23</TD><TD>20</TD><TD></TD></TR><TR><TD>2</TD><TD></TD><TD>21</TD><TD></TD><TD>211</TD></TR><TR><TD>2</TD><TD></TD><TD>21</TD><TD></TD><TD>212</TD></TR></TBODY></TABLE><P></P><P>Also trying to get a reference for building dimensional models - if anyone has recommendations.&nbsp; Thanks in advance.</P></BODY></HTML> Sat, 20 May 2017 18:04:41 GMT https://community.qlik.com/t5/QlikView/Hierarchical-facts/m-p/1304717#M406228 markp201 2017-05-20T18:04:41Z Re: Hierarchical facts https://community.qlik.com/t5/QlikView/Hierarchical-facts/m-p/1304718#M406229 <HTML><HEAD></HEAD><BODY><P>Can you explain more about the problem.</P><P>A file with data is beter.</P></BODY></HTML> Sat, 20 May 2017 18:45:23 GMT https://community.qlik.com/t5/QlikView/Hierarchical-facts/m-p/1304718#M406229 ecolomer 2017-05-20T18:45:23Z