Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

rkspareek1992
Contributor

Sum of Rows in Qliksense

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.

Community Browser