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




      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!