I have some data I am working with that looks like this:
|5456767||[55, 44, 10, 31]||22|
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!)
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