4 Replies Latest reply: May 14, 2012 2:02 PM by Saurav S RSS

    Merging Tables

      Hello,

       

      I have been trying to figure this out for a while, I am trying to merge two tables together, one table has actual results from our  customer service reps and the other table is an excel file which has the points associated with agents actual results. For ex, if an agent has a callback score of 100, then they receive 5 points and if another agent has a call score 60 then he receives 0 points and also, if you fall anywhere in that range you still receive points. I am receiving points for some agents but not all. I think its a rounding issue but I am not positive. Please help and let me know if you would like me to provide more detail.

       

      Thank you very much,

       

      I have attached the QVW for your reference.

        • Merging Tables
          Stefan Wühl

          If you look at your IR / IR_Points data, you only get IR_Points where your fourth decimal digit of the fractional part is zero.

           

          Since you are using a join in your table load and I can't see the original excel table with the mapping of IR to IR Points, I am only guessing:

           

          Does your mapping table holds only IR data with 3 decimal digits of the fractional part?

          If yes, you can try changing your line

           

          Round(1-((UR)/(IR_Calls)),-.0001) AS IR

           

          to

          Round(1-((UR)/(IR_Calls)),-.001) AS IR

           

          If not, I think a join is not the appropriate method to map your calculated IR values to the lookup values, a join is only mapping exactely matching (in this case numerical) values, i.e. it will match 1.2340 to 1.234 because they numerically match (assuming they have the same internal floating point representation), but not 1.2341 to 1.234.

           

          Hope this helps,

          Stefan

            • Merging Tables

              Hi Stefan,

               

              Thank you for a very helpful response, however, I am still not getting the results that I want. Do you recommend using another statement other than a join? I am new to Qlikview, so any suggestions would be helpful.

               

              Thanks again,

               

              Saurav

                • Merging Tables
                  Stefan Wühl

                  Hm, not sure if there is a better solution, a join seems ok to me.

                   

                  It would be good to see the excel file that you want to join, do you mind uploading it?

                   

                  And if you say, you are not getting the results you want, what exactely do you get (having changed what compared to your last file), and what do you expect?