0 Replies Latest reply: Jul 21, 2017 6:45 AM by Rakesh Pareek RSS

    Sum of Rows in Qliksense

    Rakesh Pareek

      Hi,

       

      I wants to sum of rows in qliksense. Below is the Input and desired output. Kindly help.

       

      In the table I have different dimensions and I want sum(Amt)/Sum(Qty).

       

      Dimension

      Amt/Qty

      Amt

      Qty

      Desired Output

       

      10.85

      2,253,410.81

      207,688.08

      43.89

      CHA Charges

      3.71

      190,434.15

      51,391.52

      3.71

      Freight

      4.44

      241,338.15

      54,391.48

      4.44

      ICD-CFS Chargs

      5.43

      276,527.96

      50,951.52

      5.43

      Stamp Duty

      30.32

      1,545,110.55

      50,953.57

      30.32

       

      As Desired output I want 43.89 (Sum of rows) in output Column.