2 Replies Latest reply: Oct 8, 2012 7:38 AM by Miroslav Žebrák RSS

    Looking for expression

      Hi all QV developers, would I ask you for help?

       

      I have one table with authors (DVD's) and their sales. And 2 connected sliders over triggers on variables.

       

      I am looking for expressions which will be set in triggers probably.

       

      Default state:

       

      - upper slider shows %

      - left slider shows whole numbers (integers)

      - straight table contains list of authors and their sales. Table is always sorted by sales size descending

       

      Requirements:

       

      1. When "x%" is selected on the upper slider then table show sales of products which are "x"% of total sales.

       

      2. On the left slider - how many products makes this "x"%

       

      Same in reverse.

       

      Should I use RANK or something else?

       

       

      THANKS YOU MUCH for any idea!

       

      Mirek