topic Pivot Table benchmark in Management & Governance https://community.qlik.com/t5/Management-Governance/Pivot-Table-benchmark/m-p/2052559#M24623 <P>hello all,</P> <P>I need some help with a pivot table (the expression behind is simply sum of cost). I'm still using qlik view.</P> <P>I'm using as dimensions the shop location, the product type and the provider.&nbsp; For every row, I would need to calculate the cheapest option and from which provider (eg. fist line, the min cost is 9 from the provider C)</P> <P>&nbsp;</P> <P>Please any idea how to achieve this result?</P> <P>thanks in advance</P> <TABLE width="860"> <TBODY> <TR> <TD width="178">&nbsp;</TD> <TD width="115">&nbsp;</TD> <TD width="66">EUR</TD> <TD width="66">EUR</TD> <TD width="66">EUR</TD> <TD width="66">EUR</TD> <TD width="66">EUR</TD> <TD width="19">&nbsp;</TD> <TD width="105">&nbsp;</TD> <TD width="113">&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>PROVIDER</TD> <TD>A</TD> <TD>B</TD> <TD>C</TD> <TD>D</TD> <TD>E</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>SHOP LOCATION</TD> <TD>TYPE</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>best offer</TD> <TD>best provider</TD> </TR> <TR> <TD>COUNTRY_ONE</TD> <TD>ONE</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</TD> <TD>&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</TD> <TD>C</TD> </TR> <TR> <TD>COUNTRY_ONE</TD> <TD>TWO</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 130</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 106</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</TD> <TD>A</TD> </TR> <TR> <TD>COUNTRY_TWO</TD> <TD>ONE</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 35</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 37</TD> <TD>&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 35</TD> <TD>D</TD> </TR> <TR> <TD>COUNTRY_THREE</TD> <TD>ONE</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 34</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 26</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</TD> <TD>A</TD> </TR> <TR> <TD>COUNTRY_FOUR</TD> <TD>ONE</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25</TD> <TD>C</TD> </TR> <TR> <TD>COUNTRY_FOUR</TD> <TD>TWO</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</TD> <TD>A</TD> </TR> <TR> <TD>COUNTRY_FIVE</TD> <TD>TWO</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</TD> <TD>A</TD> </TR> </TBODY> </TABLE> Thu, 23 Mar 2023 14:40:49 GMT marikabi 2023-03-23T14:40:49Z Pivot Table benchmark https://community.qlik.com/t5/Management-Governance/Pivot-Table-benchmark/m-p/2052559#M24623 <P>hello all,</P> <P>I need some help with a pivot table (the expression behind is simply sum of cost). I'm still using qlik view.</P> <P>I'm using as dimensions the shop location, the product type and the provider.&nbsp; For every row, I would need to calculate the cheapest option and from which provider (eg. fist line, the min cost is 9 from the provider C)</P> <P>&nbsp;</P> <P>Please any idea how to achieve this result?</P> <P>thanks in advance</P> <TABLE width="860"> <TBODY> <TR> <TD width="178">&nbsp;</TD> <TD width="115">&nbsp;</TD> <TD width="66">EUR</TD> <TD width="66">EUR</TD> <TD width="66">EUR</TD> <TD width="66">EUR</TD> <TD width="66">EUR</TD> <TD width="19">&nbsp;</TD> <TD width="105">&nbsp;</TD> <TD width="113">&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>PROVIDER</TD> <TD>A</TD> <TD>B</TD> <TD>C</TD> <TD>D</TD> <TD>E</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>SHOP LOCATION</TD> <TD>TYPE</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>best offer</TD> <TD>best provider</TD> </TR> <TR> <TD>COUNTRY_ONE</TD> <TD>ONE</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</TD> <TD>&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</TD> <TD>C</TD> </TR> <TR> <TD>COUNTRY_ONE</TD> <TD>TWO</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 130</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 106</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</TD> <TD>A</TD> </TR> <TR> <TD>COUNTRY_TWO</TD> <TD>ONE</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 35</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 37</TD> <TD>&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 35</TD> <TD>D</TD> </TR> <TR> <TD>COUNTRY_THREE</TD> <TD>ONE</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 34</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 26</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</TD> <TD>A</TD> </TR> <TR> <TD>COUNTRY_FOUR</TD> <TD>ONE</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25</TD> <TD>C</TD> </TR> <TR> <TD>COUNTRY_FOUR</TD> <TD>TWO</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</TD> <TD>A</TD> </TR> <TR> <TD>COUNTRY_FIVE</TD> <TD>TWO</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;n/a&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</TD> <TD>A</TD> </TR> </TBODY> </TABLE> Thu, 23 Mar 2023 14:40:49 GMT https://community.qlik.com/t5/Management-Governance/Pivot-Table-benchmark/m-p/2052559#M24623 marikabi 2023-03-23T14:40:49Z