Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Upper limit on sum count

Hi,

I would like to calculate a cost where I have the number of items and the unit price and the sum per category is (of course) calculated number of items * unit price. The total cost is the sum of all catogory sums.

I also have price ceilings for some items where a have a calculated unit price since before * the number of items UNTIL the ceiling is reached. How can I get this logic into Qlikview?