4 Replies Latest reply: Dec 5, 2013 1:58 PM by Lynn Miao RSS

    Rookie's questions...

    Lynn Miao

      I just got started self studying Qlik yesterday. I'm trying to build a sales chart showing the sales volume for different products.

      2 tables as below have been uploaded.

      Product Table: ProductID, ProductName, ListPrice, StdCost

      Order Table: OrderDate, Region, Rep, ProductID, Units.

       

      I want the dimension of the bar chart to be "ProductName"; the Expression to be "TotalSales" (Sum (ListPrices*Units) )

       

      I had no problem building it with the Expression of just the Sum of the Units, but I cannot figure out how to do multiplies in the Expression...

       

      Please, any inputs is appreciated.

       

      Thanks!!