topic Re: SAP list prices help in QlikView https://community.qlik.com/t5/QlikView/SAP-list-prices-help/m-p/1031114#M348075 <HTML><HEAD></HEAD><BODY><P>I think I found solution to this..not an easy one as I have to do several transformations but eventually got there <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 11 Mar 2016 14:27:25 GMT 2016-03-11T14:27:25Z SAP list prices help https://community.qlik.com/t5/QlikView/SAP-list-prices-help/m-p/1031113#M348074 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I need some help in data modelling so I can pull correct records. I have 2 tables which holds list price information at 2 different levels.</P><P></P><P>Table A - In this Table, List price (KBETR) is maintained at VKORG/VTWEG/MAT_GRP1 Level</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" height="49" style="height: 39px; width: 514px;"><TBODY><TR><TD class="xl63" height="17" width="45">VKORG</TD><TD class="xl63" style="border-left: none;" width="46">VTWEG</TD><TD class="xl63" style="border-left: none;" width="119">MAT_GRP_1</TD><TD class="xl63" style="border-left: none;" width="69">MATNR</TD><TD class="xl63" style="border-left: none;" width="63">DATBI</TD><TD class="xl63" style="border-left: none;" width="43">KBETR</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">GB</TD><TD class="xl64" style="border-top: none; border-left: none;">10</TD><TD class="xl64" style="border-top: none; border-left: none;">121</TD><TD class="xl64" style="border-top: none; border-left: none;">ABCD</TD><TD class="xl64" style="border-top: none; border-left: none;">2014-01-20</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">$100</TD></TR></TBODY></TABLE><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><SPAN style="font-size: 13.3333330154419px;">Table B</SPAN> - <SPAN style="font-size: 13.3333330154419px;">In this Table, List price (KBETR) is maintained at VKORG/VTWEG Level</SPAN></SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="55" style="width: 520px; height: 57px;"><TBODY><TR><TD class="xl65" height="17" width="45">VKORG</TD><TD class="xl65" style="border-left: none;" width="46">VTWEG</TD><TD class="xl65" style="border-left: none;" width="69">MATNR</TD><TD class="xl65" style="border-left: none;" width="63">DATBI</TD><TD class="xl65" style="border-left: none;" width="43">KBETR</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">GB</TD><TD class="xl66" style="border-top: none; border-left: none;">20</TD><TD class="xl66" style="border-top: none; border-left: none;">ABCD</TD><TD class="xl66" style="border-top: none; border-left: none;">9999-12-31</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">110</TD></TR></TBODY></TABLE><P></P><P>What I am looking for is</P><P>When user selects 121 value from <SPAN style="font-size: 13.3333330154419px;"> list box </SPAN>MAT_GRP_1--&gt; As the DATBI is expired (&lt; Today()) I want dashboard to go and pick up KBETR from Table 2 which is 110.</P><P></P><P>Any suggestions?</P><P>Thanks a lot</P><P>MC</P></BODY></HTML> Tue, 08 Mar 2016 17:45:52 GMT https://community.qlik.com/t5/QlikView/SAP-list-prices-help/m-p/1031113#M348074 2016-03-08T17:45:52Z Re: SAP list prices help https://community.qlik.com/t5/QlikView/SAP-list-prices-help/m-p/1031114#M348075 <HTML><HEAD></HEAD><BODY><P>I think I found solution to this..not an easy one as I have to do several transformations but eventually got there <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 11 Mar 2016 14:27:25 GMT https://community.qlik.com/t5/QlikView/SAP-list-prices-help/m-p/1031114#M348075 2016-03-11T14:27:25Z