Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
anyone?
Maybe you could implement something like this: GitHub - adam-hanna/goalSeek.js: goalSeek.js is a javascript library that can be used to solve for t... within an extension.
- Marcus
thx for the reply Marcus,
is there any sample of qlikview that using this function?
best regards
AFAIK there is no sample.
- Marcus
ok thx for the effort Marcus