Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Total sum for several dimensions

I'm using straight table and I have a problem with calculation "Total Qty" - the formula should be sum(Qty) grouped by Code.

Can anyone help me with set analysis formula?

Code

Sub codeQtyTotal Qty
111a2558
111b2358
111c1058
222a1168
222b3468
333c2368
1 Solution

Accepted Solutions

Re: Total sum for several dimensions

Try sum(total <Code> Qty)


talk is cheap, supply exceeds demand
5 Replies
sujeetsingh
Honored Contributor III

Re: Total sum for several dimensions

See this sample may be it help you!!

kumarnatarajan
Valued Contributor

Re: Total sum for several dimensions

Hi,

i don't know what you expect result. i thought you need total qty in all rows.

use this for total qty for each row

Ex: Sum(TOTAL [Total Qty])

Re: Total sum for several dimensions

Try sum(total <Code> Qty)


talk is cheap, supply exceeds demand
er_mohit
Honored Contributor II

Re: Total sum for several dimensions

Try this

aggr(sum(Total Qty),Code)

Not applicable

Re: Total sum for several dimensions

try this

Aggr(sum([Total Qty]),Code)

Community Browser