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



      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.