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?