3 Replies Latest reply: Feb 11, 2010 12:09 PM by kajok RSS

    Dependable sliders

      Did anyone run upon a problem of for exp three sliders, that should be dependable on each other?
      When I talk about dependable, I am thinking about the variables on sliders..

      So the sum those three variables should for exp be 100.
      If theirs values are A = 60, B = 30, C = 10, and for exp we change A to 70, than B should go down and also a C. I know the exactly formula which can done this, but I really can't make it work...

       

      My status of work, macro chould run on variable change and set the value of two others with formula, for B = B+ (100 - (A +B+C))/(B+C)*B

       

      Can anybody make a short example of qlikview where this works?

      Tnx.