topic Column Data Based on List Box Selection in QlikView https://community.qlik.com/t5/QlikView/Column-Data-Based-on-List-Box-Selection/m-p/334489#M1177113 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 8pt;"> </SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11; font-size: 12pt;">Let me know if my enclosed example can be done by any other simple way.</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11; font-size: 12pt;"> </SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11; font-size: 12pt;">Check some description below to understand what I want to achieve.</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11; font-size: 12pt;"> </SPAN></P><UL><LI><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11; font-size: 12pt;">I have multiple supplier i.e. SupplierA, SupplierB, SupplierC, SupplierD for different products i.e. FRUITs</SPAN></LI><LI><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11; font-size: 12pt;">My idea behind this example is to check % difference in prices of any supplier with respect to minimum price of all other supplier.</SPAN></LI><LI><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11; font-size: 12pt;">Upon selection supplier from Selection (LIST BOX PROPERTIES), respective prices from column 2,3,4 or 5 will be disappeared and column 8 will show price for the same supplier.</SPAN></LI><LI><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11; font-size: 12pt;">Column 9 will calculate % difference between price of selected supplier vs minimum price from all other supplier.</SPAN></LI></UL><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11; font-size: 12pt;"> </SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11;">Regards,<BR />Manish</SPAN><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11;"> </SPAN></SPAN></P></BODY></HTML> Tue, 03 Apr 2012 12:19:30 GMT 2012-04-03T12:19:30Z Column Data Based on List Box Selection https://community.qlik.com/t5/QlikView/Column-Data-Based-on-List-Box-Selection/m-p/334489#M1177113 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 8pt;"> </SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11; font-size: 12pt;">Let me know if my enclosed example can be done by any other simple way.</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11; font-size: 12pt;"> </SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11; font-size: 12pt;">Check some description below to understand what I want to achieve.</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11; font-size: 12pt;"> </SPAN></P><UL><LI><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11; font-size: 12pt;">I have multiple supplier i.e. SupplierA, SupplierB, SupplierC, SupplierD for different products i.e. FRUITs</SPAN></LI><LI><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11; font-size: 12pt;">My idea behind this example is to check % difference in prices of any supplier with respect to minimum price of all other supplier.</SPAN></LI><LI><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11; font-size: 12pt;">Upon selection supplier from Selection (LIST BOX PROPERTIES), respective prices from column 2,3,4 or 5 will be disappeared and column 8 will show price for the same supplier.</SPAN></LI><LI><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11; font-size: 12pt;">Column 9 will calculate % difference between price of selected supplier vs minimum price from all other supplier.</SPAN></LI></UL><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11; font-size: 12pt;"> </SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11;">Regards,<BR />Manish</SPAN><SPAN style="font-family: calibri, verdana, arial, sans-serif; color: #1d1b11;"> </SPAN></SPAN></P></BODY></HTML> Tue, 03 Apr 2012 12:19:30 GMT https://community.qlik.com/t5/QlikView/Column-Data-Based-on-List-Box-Selection/m-p/334489#M1177113 2012-04-03T12:19:30Z