Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

[ASK] Goal Seek in QlikView

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

5 Replies
Highlighted
Partner
Partner

anyone?

Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Partner
Partner

thx for the reply Marcus,

is there any sample of qlikview that using this function?

best regards

Highlighted
MVP & Luminary
MVP & Luminary

AFAIK there is no sample.

- Marcus

Highlighted
Partner
Partner

ok thx for the effort Marcus