topic Deducing maximum for variable where condition is true in QlikView https://community.qlik.com/t5/QlikView/Deducing-maximum-for-variable-where-condition-is-true/m-p/383739#M701783 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>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? </P></BODY></HTML> Tue, 04 Sep 2012 10:31:21 GMT felix18807 2012-09-04T10:31:21Z Deducing maximum for variable where condition is true https://community.qlik.com/t5/QlikView/Deducing-maximum-for-variable-where-condition-is-true/m-p/383739#M701783 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>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? </P></BODY></HTML> Tue, 04 Sep 2012 10:31:21 GMT https://community.qlik.com/t5/QlikView/Deducing-maximum-for-variable-where-condition-is-true/m-p/383739#M701783 felix18807 2012-09-04T10:31:21Z