Dear QlikView Master,
I have a client that use excel for reporting and now is implementing QlikView.
And my client use goal seek function in excel many times.
So, is there any solution to implement goal seek function in qlikview?
for example i have 3 variable and 1 basic value, and a formula to search a result.
Formula is : [RESULT] = [VALUE]+VarA+VarB-VarC.
If i use what-if analysis it will easy to find the result.
But how if user have defined result, and qlikview have to calculate/define 3 variable (VarA, VarB, VarC) to achieve the result?
for example again,
User defined :
[RESULT] = 0
[VALUE] = 50
What is the value for VarA, VarB, VarC based on qlikview calculation?
the answer could be :
VarA = 20
VarB = 30
VarC = 100
Or the answer for those 3 variables could be other than that.
Really need help here,
And many thanks,
Best Regards
