topic Re: Need help with data model in QlikView https://community.qlik.com/t5/QlikView/Need-help-with-data-model/m-p/727664#M260778 <HTML><HEAD></HEAD><BODY><P>Any ideas?</P></BODY></HTML> Tue, 22 Jul 2014 16:25:37 GMT 2014-07-22T16:25:37Z Need help with data model https://community.qlik.com/t5/QlikView/Need-help-with-data-model/m-p/727660#M260774 <HTML><HEAD></HEAD><BODY><P>Hi guys, I need some major help so any advice would be greatly appreciated. </P><P></P><P>I have two tables: Orders &amp; Cost. The orders table has a specified number of orders for a product from a specific source to a&nbsp; specific destination. The cost table has a 5 different options of possible sources for a <SPAN style="text-decoration: underline;">specific</SPAN> location.&nbsp; </P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">What I need to be able to do: I want a table or chart that shows me the product, source, destination with the three cheapest sources with their associated costs.... without actually showing each "options" from the cost table... </SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Any ideas?<BR /></SPAN></P></BODY></HTML> Tue, 22 Jul 2014 14:42:56 GMT https://community.qlik.com/t5/QlikView/Need-help-with-data-model/m-p/727660#M260774 2014-07-22T14:42:56Z Re: Need help with data model https://community.qlik.com/t5/QlikView/Need-help-with-data-model/m-p/727661#M260775 <HTML><HEAD></HEAD><BODY><P>Can you provide sample data?</P></BODY></HTML> Tue, 22 Jul 2014 14:45:32 GMT https://community.qlik.com/t5/QlikView/Need-help-with-data-model/m-p/727661#M260775 MK_QSL 2014-07-22T14:45:32Z Re: Need help with data model https://community.qlik.com/t5/QlikView/Need-help-with-data-model/m-p/727662#M260776 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>As this is quite complex, some example data would be a big help in determining suggestions for an answer?</P></BODY></HTML> Tue, 22 Jul 2014 14:51:40 GMT https://community.qlik.com/t5/QlikView/Need-help-with-data-model/m-p/727662#M260776 timsaddler 2014-07-22T14:51:40Z Re: Re: Need help with data model https://community.qlik.com/t5/QlikView/Need-help-with-data-model/m-p/727663#M260777 <HTML><HEAD></HEAD><BODY><P>Please see attachment. It is sample data and it shows how I would like it to look like.</P></BODY></HTML> Tue, 22 Jul 2014 15:05:53 GMT https://community.qlik.com/t5/QlikView/Need-help-with-data-model/m-p/727663#M260777 2014-07-22T15:05:53Z Re: Need help with data model https://community.qlik.com/t5/QlikView/Need-help-with-data-model/m-p/727664#M260778 <HTML><HEAD></HEAD><BODY><P>Any ideas?</P></BODY></HTML> Tue, 22 Jul 2014 16:25:37 GMT https://community.qlik.com/t5/QlikView/Need-help-with-data-model/m-p/727664#M260778 2014-07-22T16:25:37Z Re: Re: Re: Need help with data model https://community.qlik.com/t5/QlikView/Need-help-with-data-model/m-p/727665#M260779 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P></P><P>Please see file attached.</P><P></P><P>Regards</P><P></P><P>R</P></BODY></HTML> Tue, 22 Jul 2014 16:27:29 GMT https://community.qlik.com/t5/QlikView/Need-help-with-data-model/m-p/727665#M260779 2014-07-22T16:27:29Z Re: Need help with data model https://community.qlik.com/t5/QlikView/Need-help-with-data-model/m-p/727666#M260780 <HTML><HEAD></HEAD><BODY><P>The problem is that I have over 100's of products..........so that would make this a little difficult</P></BODY></HTML> Tue, 22 Jul 2014 16:54:36 GMT https://community.qlik.com/t5/QlikView/Need-help-with-data-model/m-p/727666#M260780 2014-07-22T16:54:36Z Re: Need help with data model https://community.qlik.com/t5/QlikView/Need-help-with-data-model/m-p/727667#M260781 <HTML><HEAD></HEAD><BODY><P>Check if fits your needs</P></BODY></HTML> Tue, 22 Jul 2014 17:11:36 GMT https://community.qlik.com/t5/QlikView/Need-help-with-data-model/m-p/727667#M260781 Clever_Anjos 2014-07-22T17:11:36Z