1 Reply Latest reply: Nov 3, 2017 2:05 PM by Sunny Talwar RSS

    Brain teaser: How to analyse multiple products ordered held in one field per order?

    John Blomqvist

      Hello all,

       

      I have some data I am working with that looks like this:

       

      ProductTable:


      ProductIDName
      10Shirt
      31Shoes
      44Wallet
      55Jeans

       

      OrdersTable:

         

      OrderIDProductIDQuanity
      432313[10]3
      56676[31, 55]34
      232323[]66
      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!)