Aggregation sum over a particular dimension in a table chart

ruma_barman — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

My requirement is I need to show the aggregate sum against a particular dimension.

Here for e.g if there are 2 document numbers against particular asset number the value of the asset i.e the output should be distinct sum of it alongwith aggregation over documentno as below:

Input :

DocumentNo,AssetNo,Value

D1,A1,11

D2,A2,22

D3,A2,33

Output:

DocumentNo,AssetNo,Value

D1,A1,11

D2,A2,55

D3,A2,55

Thanks in advance,

Ruma

Re: Aggregation sum over a particular dimension in a table chart

tresB — Mon, 05 Nov 2018 09:37:29 GMT

Try:

Sum( total <AssetNo> DISTINCT Value)

topic Re: Aggregation sum over a particular dimension in a table chart in QlikView

Aggregation sum over a particular dimension in a table chart

Re: Aggregation sum over a particular dimension in a table chart