topic Re: Dimensions and Facts in QV in QlikView https://community.qlik.com/t5/QlikView/Dimensions-and-Facts-in-QV/m-p/598423#M1119306 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><H1 style="font-weight: normal; font-size: 26px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f5faf0;"><A _jive_internal="true" class="font-color-normal" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/03/25/dimensions-and-measures" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3d3d3d;">Dimensions and Measures</A></H1><P></P><P>Read the blog posted by Henric will be helpful to you understand </P><P>regards</P><P>Mahesh</P></BODY></HTML> Mon, 03 Feb 2014 06:41:23 GMT 2014-02-03T06:41:23Z Dimensions and Facts in QV https://community.qlik.com/t5/QlikView/Dimensions-and-Facts-in-QV/m-p/598422#M1119305 <HTML><HEAD></HEAD><BODY><H1><SPAN style="color: #ff6600;">Hi,</SPAN></H1><P></P><H1><SPAN style="color: #ff6600;">I am new to BI &amp; QV.</SPAN></H1><H1><SPAN style="color: #ff6600;">I want to know about Dimensions and Facts in QV..</SPAN></H1><H1></H1><H1><SPAN style="color: #ff6600;">Please share your thoughts on this please</SPAN></H1><H1></H1><H1><SPAN style="color: #00ffff;"><SPAN style="color: #ff6600;">Thanks in Advance.</SPAN>..</SPAN>.</H1></BODY></HTML> Mon, 03 Feb 2014 06:39:25 GMT https://community.qlik.com/t5/QlikView/Dimensions-and-Facts-in-QV/m-p/598422#M1119305 2014-02-03T06:39:25Z Re: Dimensions and Facts in QV https://community.qlik.com/t5/QlikView/Dimensions-and-Facts-in-QV/m-p/598423#M1119306 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><H1 style="font-weight: normal; font-size: 26px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f5faf0;"><A _jive_internal="true" class="font-color-normal" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/03/25/dimensions-and-measures" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3d3d3d;">Dimensions and Measures</A></H1><P></P><P>Read the blog posted by Henric will be helpful to you understand </P><P>regards</P><P>Mahesh</P></BODY></HTML> Mon, 03 Feb 2014 06:41:23 GMT https://community.qlik.com/t5/QlikView/Dimensions-and-Facts-in-QV/m-p/598423#M1119306 2014-02-03T06:41:23Z Re: Dimensions and Facts in QV https://community.qlik.com/t5/QlikView/Dimensions-and-Facts-in-QV/m-p/598424#M1119307 <HTML><HEAD></HEAD><BODY><P>Consider you are working in a sales environment...</P><P></P><P>Dimensions are (Slowly Changing)</P><P>Customer, CustomerName, CustomerID, Supplier, SupplierID, SupplierName, Customer/Supplier Address, </P><P>EmployeeName, EmployeeID etc...</P><P></P><P>Facts Data/Tables are (Updating daily/regularly)</P><P>Invoice Qty, Invoice Price, Invoice Date etc...</P><P></P><P>Hope this help</P></BODY></HTML> Mon, 03 Feb 2014 06:42:18 GMT https://community.qlik.com/t5/QlikView/Dimensions-and-Facts-in-QV/m-p/598424#M1119307 MK_QSL 2014-02-03T06:42:18Z Re: Dimensions and Facts in QV https://community.qlik.com/t5/QlikView/Dimensions-and-Facts-in-QV/m-p/598425#M1119308 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt; background: white;"><STRONG style="color: #333333; font-size: 13.5pt;">Dimension -</STRONG></P><P style="margin-bottom: .0001pt; background: white;"><SPAN style="font-size: 13.5pt; color: #333333;">A dimension table typically has two types of columns, primary keys to fact tables and textual\descreptive data.</SPAN></P><P style="margin-bottom: .0001pt; background: white;"><STRONG style="color: #333333; font-size: 13.5pt;">Fact -</STRONG><STRONG style="color: #333333; font-size: 13.5pt;"><BR /> </STRONG><SPAN style="font-size: 13.5pt; color: #333333;">A fact table typically has two types of columns, foreign keys to dimension tables and measures those that contain numeric facts. A fact table can contain fact’s data on detail or aggregated level.</SPAN></P><P style="background-color: white;">regards</P><P style="background-color: white;">Mahesh T</P></BODY></HTML> Mon, 03 Feb 2014 06:49:16 GMT https://community.qlik.com/t5/QlikView/Dimensions-and-Facts-in-QV/m-p/598425#M1119308 2014-02-03T06:49:16Z