2 Replies Latest reply: May 15, 2014 6:45 AM by André Holmström RSS

    Problem with expresion

    André Holmström

      Hi,

       

      Im kinda new to Qlikview, done basic training in Stockholm.

       

      My question or my problem consist of.

       

      I try to make a chart that shows quality kitchen percentage in a chart with top ten salesman.

       

      qualitykitchen is a variabel with 1 or null.

      orderId is the other variabel im that is unique for all orders.

       

      So when i do my selection qualitykitchen :

       

      I can see the total amount of qualitykitchen the top salesman has made, but its not representative though it doesent take in consider how many kitchen they sold. So i would like to make an expression that divide qualitykicthen with amount sold kitchen. That would give me a percentage that is representative.

       

      But i dont seems to be able to create that.

       

      Anyone that can point me in the right direction?

       

      Thx in advance and sorry for the bad spelling.

       

      /André