1 Reply Latest reply: Jan 20, 2014 6:47 AM by sujeet singh RSS

    Sum from 2 different tables

    Ruytter Mendonça

      Hi, i'm new in qlikview and in the SQL world, so i'm having a little trouble lately.

       

      I have two tables: Sales and Budget.

      And I want to compare sales x budget to see how the thing goes.

       

      But the problem is that i'm not able to create a pivot table from the Budget table and sum the amount of sales on it with a set analisys to the salesman or to the product as is on the budget table.

       

      So, i imagine that i might do something on the script, or even in the pivot table but i cant figure out.

      So, if anyone can help me, i would apreciate.

      Thanks