Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
yvonne-c
Contributor

Calculate based on rules / selections

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?

1 Reply

Re: Calculate based on rules / selections

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