Calculate based on rules / selections

yvonne-c — Tue, 26 Jul 2016 11:56:51 GMT

I have an app where I am calculating the number of courses of a product used by a client. Tables are similar to below and I am calculating Sum({<Target weight = {A}>}Quantity)/Course

Stock table

Product

Target weight - (A or B)

Course

Client Table

Client ID

Sales

Client ID

Product

Quantity

A product has a target weight set at A or B - this will generally be correct

But occasionally a product may be used in the other target weight which would result in a different course rate

I need to find a way to set the target weight for a product depending on the client

So when I select a client the product is calculated at the correct rate for the correct target weight

Hope that makes sense! Can anyone advise a way to achieve this?

Re: Calculate based on rules / selections

sunny_talwar — Tue, 26 Jul 2016 12:20:13 GMT

Can you provide some sample data with the expected output to help you better?

topic Re: Calculate based on rules / selections in QlikView

Calculate based on rules / selections

Re: Calculate based on rules / selections