Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
New Contributor III

Deducing maximum for variable where condition is true

I have a complex pricing model example here but what I want to do is calculate one of the maximum for one of the variables (cost) where the Selling price = Target price. The issue is complicated by the fact that part of the selling price calculation is the cost.

I think this may not be possible but I feel obliged to ask is there any way of incrementing through the cost variable until Target Price = Selling Price then presenting this value in the straight table?

Community Browser