topic How to define Star Schema data modeling ? in QlikView https://community.qlik.com/t5/QlikView/How-to-define-Star-Schema-data-modeling/m-p/1156003#M900473 <HTML><HEAD></HEAD><BODY><P>Hello , i am new to Qlik view Reporting process ,</P><P></P><P>&nbsp;&nbsp;&nbsp; I have log file&nbsp; ( which looks like this )</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><P><STRONG>------------DEVICE-------</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; HARDWARE:&nbsp;&nbsp; SAMSUNG </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SOFTWARE:&nbsp; Android</STRONG></P><P>----------------------------------</P><P><STRONG>Tested started : 11/2/2016</STRONG></P><P></P><P><STRONG>Testcase: GUITEST1.0.1</STRONG></P><P><STRONG> no of iteration:1</STRONG></P><P>----------------------------</P><P><STRONG>interation 1 : pass </STRONG></P><P><STRONG>XValues : 1, 4, 6, 7, 8, 9, 10</STRONG></P><P><STRONG>Yvalues:&nbsp; 1.0,2.02,3.0,5.0</STRONG></P><P><SPAN style="font-size: 13.3333px;">--------------------------------------------</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><STRONG>interation 2: pass </STRONG></P><P style="font-size: 13.3333px;"><STRONG>XValues : 1, 4, 6, 7, 8, 9, 10</STRONG></P><P style="font-size: 13.3333px;"><STRONG>Yvalues:&nbsp; 2.0,2.02,3.0,5.0</STRONG></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">---------<BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Tested done : 11/2/2016</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Avg of all interation</SPAN></P><P style="font-size: 13.3333px;">Number of iterations: 2</P><P style="font-size: 13.3333px;">Number of success iterations: 2</P><P style="font-size: 13.3333px;">XValues : 1, 4, 6, 7, 8, 9, 10</P><P style="font-size: 13.3333px;">Yvalues:&nbsp; 2.0,2.02,3.0,5.0</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">--------------------------------------</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">i have a&nbsp; create a model like this is good approach ? </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/131237_Capture.JPG" style="height: 241px; width: 620px;" /></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">please guide me if i am wrong ?</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Thanks </P><P style="font-size: 13.3333px;">Rohi</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z How to define Star Schema data modeling ? https://community.qlik.com/t5/QlikView/How-to-define-Star-Schema-data-modeling/m-p/1156003#M900473 <HTML><HEAD></HEAD><BODY><P>Hello , i am new to Qlik view Reporting process ,</P><P></P><P>&nbsp;&nbsp;&nbsp; I have log file&nbsp; ( which looks like this )</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><P><STRONG>------------DEVICE-------</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; HARDWARE:&nbsp;&nbsp; SAMSUNG </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SOFTWARE:&nbsp; Android</STRONG></P><P>----------------------------------</P><P><STRONG>Tested started : 11/2/2016</STRONG></P><P></P><P><STRONG>Testcase: GUITEST1.0.1</STRONG></P><P><STRONG> no of iteration:1</STRONG></P><P>----------------------------</P><P><STRONG>interation 1 : pass </STRONG></P><P><STRONG>XValues : 1, 4, 6, 7, 8, 9, 10</STRONG></P><P><STRONG>Yvalues:&nbsp; 1.0,2.02,3.0,5.0</STRONG></P><P><SPAN style="font-size: 13.3333px;">--------------------------------------------</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><STRONG>interation 2: pass </STRONG></P><P style="font-size: 13.3333px;"><STRONG>XValues : 1, 4, 6, 7, 8, 9, 10</STRONG></P><P style="font-size: 13.3333px;"><STRONG>Yvalues:&nbsp; 2.0,2.02,3.0,5.0</STRONG></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">---------<BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Tested done : 11/2/2016</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Avg of all interation</SPAN></P><P style="font-size: 13.3333px;">Number of iterations: 2</P><P style="font-size: 13.3333px;">Number of success iterations: 2</P><P style="font-size: 13.3333px;">XValues : 1, 4, 6, 7, 8, 9, 10</P><P style="font-size: 13.3333px;">Yvalues:&nbsp; 2.0,2.02,3.0,5.0</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">--------------------------------------</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">i have a&nbsp; create a model like this is good approach ? </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/131237_Capture.JPG" style="height: 241px; width: 620px;" /></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">please guide me if i am wrong ?</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Thanks </P><P style="font-size: 13.3333px;">Rohi</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-define-Star-Schema-data-modeling/m-p/1156003#M900473 2020-11-25T16:16:04Z