0 Replies Latest reply: Aug 2, 2013 9:03 AM by Bruno Martins Lêdo RSS

    SUM PRODUCT function in Qlikview

    Bruno Martins Lêdo

      Hello,

       

      I have a problem with an indicator.

       

      I need to calcul the coverage of my product stock by my model stock (my security stock) by Store.

       

      I have find a expression, I have the good total by Store and Article but not the good detail (see the column HK11 normaly I have in total of this column 50% and I have 0%) by Store.

       

      We can see the second table it's a aggregation of Store and Article and I Have the good results.

       

      I don't understand why I don't have the good result can you help me please ?

       

      You can find  below the QVW with the exemples and my Excel File with the expected results.

       

      Bruno