Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
yvonne-c
Creator
Creator

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
sunny_talwar

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