Discussion Board for collaboration regarding Qlik DataMarket.
Hopefully you can help me out.
I'm working with two Excel-Datas. The first one has the following information:
It contains the name of the product and the sales quantity.
The second Data looks like this:
It also contains the name of the product but it does contain a Limit for Sales Quantity
What i want to do with Qlik Sense is the following:
I only want to count the sales of a product which have a bigger quantity than the Limit.
The result would be:
I tried the following:
that doesn't work.
doesn't work ether.
Could you help me out? Thank you very much.
Go to Solution.
Try this expression:
=Sum(If([Sales Quantity] >= [Limit for Sales Quantity], 1, 0))
Thank You very much it worked !