topic Re: How to bring these values as dimensions? in QlikView https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23823#M772400 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I think you want ItemID as dimension,</P><P></P><P>and in expression : max(MapPrice) and max(SalesPrice)</P><P></P><P>regards</P></BODY></HTML> Tue, 29 May 2018 11:24:47 GMT ogautier62 2018-05-29T11:24:47Z How to bring these values as dimensions? https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23822#M772399 <HTML><HEAD></HEAD><BODY><P>Hi Qlik Experts,</P><P></P><P>I have the following dummy data:</P><P>**EDITED DUMMY DATA FOR INCLUDING ANOTHER SCENARIO*</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>ItemID</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>FromDate</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>ToDate</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>MapPrice</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>PriceList</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>SalesPrice</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00572-393</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">169.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">475</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00572-393</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">20170724</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">285</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">268</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00572-514</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">199.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">475</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00572-515</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">291</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">485</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00572-516</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">306</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">510</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00572-517</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">312</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">520</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00573-009</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00573-010</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00573-011</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00573-013</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00573-014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00573-016</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00573-017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00573-022</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00573-022</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">20170725</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">279.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">400</SPAN></TD></TR></TBODY></TABLE><P></P><P>I have a straight table(with a lot of expressions) where I want to add Map Price and Sales Price as <SPAN style="text-decoration: underline;"><SPAN style="color: #ff0000; text-decoration: underline;">dimensions</SPAN></SPAN>. My data brings in multiple records for certain Items.</P><P></P><P>If there are multiple records, the user should see only the max Map Price, and the corresponding Sales Price. So the expected output will be like this:</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>ItemID</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>MapPrice</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>SalesPrice</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00572-393</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">285</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">268</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00572-514</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">199.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">475</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00572-515</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">291</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">485</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00572-516</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">306</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">510</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00572-517</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">312</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">520</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00573-009</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00573-010</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00573-011</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00573-013</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00573-014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00573-016</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00573-017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">00573-022</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">279.99</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">400</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>I'm having a hard time achieving this - any help appreciated <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Regards,</P><P>Benazir</P><P></P><P>(PFA the dummy QVW)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23822#M772399 Anonymous 2020-11-25T16:16:04Z Re: How to bring these values as dimensions? https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23823#M772400 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I think you want ItemID as dimension,</P><P></P><P>and in expression : max(MapPrice) and max(SalesPrice)</P><P></P><P>regards</P></BODY></HTML> Tue, 29 May 2018 11:24:47 GMT https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23823#M772400 ogautier62 2018-05-29T11:24:47Z Re: How to bring these values as dimensions? https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23824#M772401 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Something like:</P><P></P><P><IMG alt="2018-05-29 13_26_04-QlikView - [C__Users_ES33517470F_Downloads_Item Prices as Dimensions.qvw_].png" class="jive-image image-1" src="/legacyfs/online/203777_2018-05-29 13_26_04-QlikView - [C__Users_ES33517470F_Downloads_Item Prices as Dimensions.qvw_].png" style="height: auto;" /></P><P></P><P>Saludos</P></BODY></HTML> Tue, 29 May 2018 11:27:27 GMT https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23824#M772401 fvelascog72 2018-05-29T11:27:27Z Re: How to bring these values as dimensions? https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23825#M772402 <HTML><HEAD></HEAD><BODY><P>No Oliver - I have Item ID as a dimension already along with a lot of other expressions in my straight table. I need Map Price and Sales Price as additional dimensions in my straight table.</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 29 May 2018 11:28:09 GMT https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23825#M772402 Anonymous 2018-05-29T11:28:09Z Re: How to bring these values as dimensions? https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23826#M772403 <HTML><HEAD></HEAD><BODY><P>Use this as dimension</P><P></P><P><STRONG>Aggr(Max(MapPrice), ItemID)</STRONG></P><P><STRONG>Aggr(Max(SalesPrice), ItemID)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/203775_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 29 May 2018 11:28:38 GMT https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23826#M772403 sunny_talwar 2018-05-29T11:28:38Z Re: How to bring these values as dimensions? https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23827#M772404 <HTML><HEAD></HEAD><BODY><P>Use calculated dimension like:</P><P></P><P>=Aggr(Max(MapPrice),ItemID)</P><P>=Aggr(Max(SalesPrice),ItemID)</P></BODY></HTML> Tue, 29 May 2018 11:29:55 GMT https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23827#M772404 tresB 2018-05-29T11:29:55Z Re: How to bring these values as dimensions? https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23828#M772405 <HTML><HEAD></HEAD><BODY><P>I can't use Max(SalesPrice) - what if the data changes to something like this:</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="border: 0px; font-size: 9pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><THEAD style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TR bgcolor="#f5f5f5" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TH class="header headerSortDown" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; text-align: left; background-position: no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">ItemID</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; text-align: left; background-position: no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">FromDate</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; text-align: left; background-position: no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">ToDate</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; text-align: left; background-position: no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">MapPrice</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; text-align: left; background-position: no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">PriceList</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; text-align: left; background-position: no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">SalesPrice</STRONG></SPAN></TH></TR></THEAD><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-393</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">169.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">475</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-393</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">20170724</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">285</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">268</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-514</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">199.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">475</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-515</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">291</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">485</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-516</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">306</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">510</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-517</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">312</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">520</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-009</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-010</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-011</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-013</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-014</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-016</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-017</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-022</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-022</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">20170725</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">279.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">400</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>My expected output has to be:</P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="border: 0px; font-size: 9pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><THEAD style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TR bgcolor="#f5f5f5" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; text-align: left; background-position: no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">ItemID</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; text-align: left; background-position: no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">MapPrice</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; text-align: left; background-position: no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">SalesPrice</STRONG></SPAN></TH></TR></THEAD><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-393</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">285</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">268</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-514</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">199.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">475</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-515</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">291</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">485</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-516</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">306</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">510</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-517</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">312</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">520</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-009</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-010</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-011</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-013</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-014</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-016</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-017</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-022</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">279.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">400</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 29 May 2018 11:30:35 GMT https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23828#M772405 Anonymous 2018-05-29T11:30:35Z Re: How to bring these values as dimensions? https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23829#M772406 <HTML><HEAD></HEAD><BODY><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">I can't use Max(SalesPrice) - what if the data changes to something like this:</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="border: 0px; font-weight: inherit; font-style: inherit; font-size: 9pt;"><THEAD style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TR bgcolor="#f5f5f5" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TH class="headerSortDown header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; text-align: left; background-position: no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">ItemID</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; text-align: left; background-position: no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">FromDate</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; text-align: left; background-position: no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">ToDate</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; text-align: left; background-position: no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">MapPrice</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; text-align: left; background-position: no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">PriceList</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; text-align: left; background-position: no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">SalesPrice</STRONG></SPAN></TH></TR></THEAD><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-393</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">169.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">475</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-393</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">20170724</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">285</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">268</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-514</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">199.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">475</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-515</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">291</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">485</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-516</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">306</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">510</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-517</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">312</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">520</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-009</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-010</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-011</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-013</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-014</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-016</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-017</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-022</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-022</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">20170725</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">279.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">99999</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">400</SPAN></TD></TR></TBODY></TABLE><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">My expected output has to be:</P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="border: 0px; font-weight: inherit; font-style: inherit; font-size: 9pt;"><THEAD style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TR bgcolor="#f5f5f5" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; text-align: left; background-position: no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">ItemID</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; text-align: left; background-position: no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">MapPrice</STRONG></SPAN></TH><TH class="header" nowrap="nowrap" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit; text-align: left; background-position: no-repeat;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;"><STRONG style="font-style: inherit; font-family: inherit;">SalesPrice</STRONG></SPAN></TH></TR></THEAD><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-393</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">285</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">268</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-514</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">199.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">475</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-515</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">291</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">485</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-516</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">306</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">510</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00572-517</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">312</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">520</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-009</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-010</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-011</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-013</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">184.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">264</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-014</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-016</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-017</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">174.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">250</SPAN></TD></TR><TR bgcolor="#ffffff" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">00573-022</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">279.99</SPAN></TD><TD bgcolor="#ffffff" style="padding-right: 4px; padding-left: 4px; border: 1px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #363636;">400</SPAN></TD></TR></TBODY></TABLE><P class="jive-thread-reply-btn" style="margin: 15px 0 -10px; font-size: 0.9em; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><DIV class="jive-thread-reply-btn-correct" style="font-weight: inherit; font-style: inherit; font-size: 11.7px; font-family: inherit;"><A _jive_internal="true" href="https://community.qlik.com/message/1493724" style="margin: 0 20px 0 0; padding: 2px 14px 4px 28px; font-weight: bold; font-style: inherit; font-size: 11.7px; font-family: inherit; color: #3778c7; background-color: #f3f3f3;">Re: How to bring these values as dimensions?</A><P></P><P>Sorry about the confusion - I need the record which has max(mapPrice) and the corresponding Sales Price.</P></DIV></BODY></HTML> Tue, 29 May 2018 11:33:51 GMT https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23829#M772406 Anonymous 2018-05-29T11:33:51Z Re: How to bring these values as dimensions? https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23830#M772407 <HTML><HEAD></HEAD><BODY><P>Thank you. Please refer to edited dummy data.</P></BODY></HTML> Tue, 29 May 2018 11:37:00 GMT https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23830#M772407 Anonymous 2018-05-29T11:37:00Z Re: How to bring these values as dimensions? https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23831#M772408 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>=Aggr(If(NoOfRows() - RowNo() + 1 = 1, MapPrice), ItemID, MapPrice)</STRONG></P><P><STRONG>=Aggr(If(NoOfRows() - RowNo() + 1 = 1, SalesPrice), ItemID, SalesPrice)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/203776_Capture.PNG" style="height: 349px; width: 620px;" /></P></BODY></HTML> Tue, 29 May 2018 11:42:50 GMT https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23831#M772408 sunny_talwar 2018-05-29T11:42:50Z Re: How to bring these values as dimensions? https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23832#M772409 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Hi Sunny,</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">I tried this and it works fine only if there are 2 duplicates. If there are more than 2 records for a given Item ID, then this isn't working.</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt;">Benazir </SPAN></P></BODY></HTML> Tue, 29 May 2018 11:56:00 GMT https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23832#M772409 Anonymous 2018-05-29T11:56:00Z Re: How to bring these values as dimensions? https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23833#M772410 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample where this isn't working? Because for me it is working... I added another row for 00572-393</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/203783_Capture.PNG" style="height: 338px; width: 620px;" /></P></BODY></HTML> Tue, 29 May 2018 12:07:16 GMT https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23833#M772410 sunny_talwar 2018-05-29T12:07:16Z Re: How to bring these values as dimensions? https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23834#M772411 <HTML><HEAD></HEAD><BODY><P>Look closely Sunny - for the first Item ID it reflect 6 and 7 as MAP and sales prices. It should ideally display max of map price - 285 and corresponding sales price 268.</P></BODY></HTML> Tue, 29 May 2018 12:09:27 GMT https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23834#M772411 Anonymous 2018-05-29T12:09:27Z Re: How to bring these values as dimensions? https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23835#M772412 <HTML><HEAD></HEAD><BODY><P>My bad, I mis-read your requirement... try this</P><P></P><P><STRONG>=Aggr(Max(MapPrice), ItemID)</STRONG></P><P><STRONG>=Aggr(FirstSortedValue(SalesPrice, -MapPrice), ItemID)</STRONG></P></BODY></HTML> Tue, 29 May 2018 12:15:55 GMT https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23835#M772412 sunny_talwar 2018-05-29T12:15:55Z Re: How to bring these values as dimensions? https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23836#M772413 <HTML><HEAD></HEAD><BODY><P>Fabulous!! This works like a charm.</P><P></P><P>You're a life saver Sunny <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /> <SPAN style="font-size: 10pt;">Thanks a ton!</SPAN></P><P></P><P>Regards,</P><P>Benazir</P></BODY></HTML> Tue, 29 May 2018 12:26:24 GMT https://community.qlik.com/t5/QlikView/How-to-bring-these-values-as-dimensions/m-p/23836#M772413 Anonymous 2018-05-29T12:26:24Z