topic Data model suggestions in QlikView https://community.qlik.com/t5/QlikView/Data-model-suggestions/m-p/16864#M2787 <HTML><HEAD></HEAD><BODY><P>Not looking for an outright solutions, just a few nudges.</P><P></P><P>Operational data</P><TABLE border="1" class="jiveBorder" height="50" style="border: 1px solid rgb(0, 0, 0); width: 392px; height: 45px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Person<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Location</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Widget</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Quality check</STRONG></TH></TR><TR><TD style="padding: 2px;">P1</TD><TD style="padding: 2px;">L1</TD><TD style="padding: 2px;">D1</TD><TD style="padding: 2px;">W1</TD><TD style="padding: 2px;"><P>5</P></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">P2</TD><TD style="padding: 2px;">L1</TD><TD style="padding: 2px;">D2</TD><TD style="padding: 2px;">W1</TD><TD style="padding: 2px;">6</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">P3</TD><TD style="padding: 2px;">L2</TD><TD style="padding: 2px;">D3</TD><TD style="padding: 2px;">W2</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">P4</TD><TD style="padding: 2px;">L1</TD><TD style="padding: 2px;">D3</TD><TD style="padding: 2px;">W2</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">P5</TD><TD style="padding: 2px;">L3</TD><TD style="padding: 2px;">D2</TD><TD style="padding: 2px;">W3</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">P1</TD><TD style="padding: 2px;">L1</TD><TD style="padding: 2px;">D3</TD><TD style="padding: 2px;">W3</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>This is a set of quality ratings at various locations performed by quality personnel on various dates.&nbsp; The only conforming item is the widget.</P><P>We need to analyze the discrepancy between these events.&nbsp; I figure the quality checks and discrepancy would be the measures but for each dimension I have two values.&nbsp; I've read wic's article when dealing with multiple dates but wonder if this will work for person and location as well?</P><P></P><P>Any suggestions would be appreciated. Hopefully, this has been explained well enough.&nbsp; Thanks</P></BODY></HTML> Mon, 29 Jan 2018 18:53:06 GMT markp201 2018-01-29T18:53:06Z Data model suggestions https://community.qlik.com/t5/QlikView/Data-model-suggestions/m-p/16864#M2787 <HTML><HEAD></HEAD><BODY><P>Not looking for an outright solutions, just a few nudges.</P><P></P><P>Operational data</P><TABLE border="1" class="jiveBorder" height="50" style="border: 1px solid rgb(0, 0, 0); width: 392px; height: 45px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Person<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Location</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Widget</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Quality check</STRONG></TH></TR><TR><TD style="padding: 2px;">P1</TD><TD style="padding: 2px;">L1</TD><TD style="padding: 2px;">D1</TD><TD style="padding: 2px;">W1</TD><TD style="padding: 2px;"><P>5</P></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">P2</TD><TD style="padding: 2px;">L1</TD><TD style="padding: 2px;">D2</TD><TD style="padding: 2px;">W1</TD><TD style="padding: 2px;">6</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">P3</TD><TD style="padding: 2px;">L2</TD><TD style="padding: 2px;">D3</TD><TD style="padding: 2px;">W2</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">P4</TD><TD style="padding: 2px;">L1</TD><TD style="padding: 2px;">D3</TD><TD style="padding: 2px;">W2</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">P5</TD><TD style="padding: 2px;">L3</TD><TD style="padding: 2px;">D2</TD><TD style="padding: 2px;">W3</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">P1</TD><TD style="padding: 2px;">L1</TD><TD style="padding: 2px;">D3</TD><TD style="padding: 2px;">W3</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>This is a set of quality ratings at various locations performed by quality personnel on various dates.&nbsp; The only conforming item is the widget.</P><P>We need to analyze the discrepancy between these events.&nbsp; I figure the quality checks and discrepancy would be the measures but for each dimension I have two values.&nbsp; I've read wic's article when dealing with multiple dates but wonder if this will work for person and location as well?</P><P></P><P>Any suggestions would be appreciated. Hopefully, this has been explained well enough.&nbsp; Thanks</P></BODY></HTML> Mon, 29 Jan 2018 18:53:06 GMT https://community.qlik.com/t5/QlikView/Data-model-suggestions/m-p/16864#M2787 markp201 2018-01-29T18:53:06Z