https://community.qlik.com/t5/QlikView/Qlikview-Query-to-identify-data-into-the-same-table/m-p/1592247#M456614 <P>Hi!</P><P>I'm building a model to improve perfomance on an area of my company to find inefficiencies on the purchasing behaviour of Procument.&nbsp; But right now I have some problems. I'm kind of new in Qlikview, so far I have being able to almost finish the project, but this part it's getting me crazy. I hope I can explain it with some pictures, because I don't have any code to achive that, I even tried splitting the data on different tables but I still don't get it.</P><P>I have a set of data which must be complemented depending on the data itself.&nbsp;</P><P>In the picture you can see the data base. What I want to do is to fill PPM (maked in yellow). The name of the rows are the ones marked in grey.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2019_06_14_21_54_05_Cuadraturas.xls_Modo_de_compatibilidad_Excel.png" style="width: 606px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/13820i232BDF620D15B1E4/image-size/large?v=v2&amp;px=999" role="button" title="2019_06_14_21_54_05_Cuadraturas.xls_Modo_de_compatibilidad_Excel.png" alt="2019_06_14_21_54_05_Cuadraturas.xls_Modo_de_compatibilidad_Excel.png" /></span></P><P>The logic behind this, is to review the purchases of my procurement team, where I calculate the inefficiency and missing opportunities based on price.&nbsp;</P><P>The rules I use are, if you bought in your actual month at a higher price than the "Lowest Price", you have an inefficiency.&nbsp;</P><P>The Lowest Price is defined by if you buy at 1,916 from supplier 00000001086, but in a frame of time of 3 month you have bought to any other supplier at a lower price, you have an inefficiency.&nbsp;</P><P>As far I already have identify the lowest price for each supplier. The problem is I must find the Period when this price was used.</P><P>In the case I show in the picture, the lowest price is 1,781 wich was bought to supplier 000001118 on January19.&nbsp;</P><P>How could I writte down a code to fill the PPM(Lowest Price) column with the period as the example showed?</P><P>Sorry if my english is not so good, not my native language. If you need more info please let me know or if I must change something.</P><P>Regards,</P> Sat, 16 Nov 2024 03:17:42 GMT FPC 2024-11-16T03:17:42Z https://community.qlik.com/t5/QlikView/Qlikview-Query-to-identify-data-into-the-same-table/m-p/1592247#M456614 <P>Hi!</P><P>I'm building a model to improve perfomance on an area of my company to find inefficiencies on the purchasing behaviour of Procument.&nbsp; But right now I have some problems. I'm kind of new in Qlikview, so far I have being able to almost finish the project, but this part it's getting me crazy. I hope I can explain it with some pictures, because I don't have any code to achive that, I even tried splitting the data on different tables but I still don't get it.</P><P>I have a set of data which must be complemented depending on the data itself.&nbsp;</P><P>In the picture you can see the data base. What I want to do is to fill PPM (maked in yellow). The name of the rows are the ones marked in grey.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2019_06_14_21_54_05_Cuadraturas.xls_Modo_de_compatibilidad_Excel.png" style="width: 606px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/13820i232BDF620D15B1E4/image-size/large?v=v2&amp;px=999" role="button" title="2019_06_14_21_54_05_Cuadraturas.xls_Modo_de_compatibilidad_Excel.png" alt="2019_06_14_21_54_05_Cuadraturas.xls_Modo_de_compatibilidad_Excel.png" /></span></P><P>The logic behind this, is to review the purchases of my procurement team, where I calculate the inefficiency and missing opportunities based on price.&nbsp;</P><P>The rules I use are, if you bought in your actual month at a higher price than the "Lowest Price", you have an inefficiency.&nbsp;</P><P>The Lowest Price is defined by if you buy at 1,916 from supplier 00000001086, but in a frame of time of 3 month you have bought to any other supplier at a lower price, you have an inefficiency.&nbsp;</P><P>As far I already have identify the lowest price for each supplier. The problem is I must find the Period when this price was used.</P><P>In the case I show in the picture, the lowest price is 1,781 wich was bought to supplier 000001118 on January19.&nbsp;</P><P>How could I writte down a code to fill the PPM(Lowest Price) column with the period as the example showed?</P><P>Sorry if my english is not so good, not my native language. If you need more info please let me know or if I must change something.</P><P>Regards,</P> Sat, 16 Nov 2024 03:17:42 GMT https://community.qlik.com/t5/QlikView/Qlikview-Query-to-identify-data-into-the-same-table/m-p/1592247#M456614 FPC 2024-11-16T03:17:42Z https://community.qlik.com/t5/QlikView/Qlikview-Query-to-identify-data-into-the-same-table/m-p/1602924#M456615 <P>Well, I do not have a definitive answer for you, but I have something that might help you out:</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog</A></P> <P>Do some searching in that area, there is a lot of good development related material in that area, hopefully something will be of help there to help you get this app finished.&nbsp; Sorry I am not more help.</P> <P>Regards,<BR />Brett</P> Tue, 16 Jul 2019 21:57:50 GMT https://community.qlik.com/t5/QlikView/Qlikview-Query-to-identify-data-into-the-same-table/m-p/1602924#M456615 Brett_Bleess 2019-07-16T21:57:50Z