Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Column Data Based on List Box Selection

Let me know if my enclosed example can be done by any other simple way.

Check some description below to understand what I want to achieve.

  • I have multiple supplier i.e. SupplierA, SupplierB, SupplierC, SupplierD for different products i.e. FRUITs
  • My idea behind this example is to check % difference in prices of any supplier with respect to minimum price of all other supplier.
  • 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.
  • Column 9 will calculate % difference between price of selected supplier vs minimum price from all other supplier.