Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have some data I am working with that looks like this:
You can see the problem
Some orders can have one product
Some orders can have multiple products
Some orders can have no products (yes)
What I have to do is provide number of orders per product (e.g. something like a Bar Chart).
How can I provide this accurately as possible using Qlik?
(The data is not great I know!)
Go to Solution.
I would create a new field using SubField function to make your life easier here
SubField(ProductID, ', ') as UniqueProductID
One you do this, create a chart with