Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

alakazam
New Contributor III

Sum in class table

Hello for all Qlik mages! :-) Can anybody help me with tables? In first table I have prepared data and I need make sum for each "Material" (column Total stock/Psc Per pa) and final sum for each distinct Material get to second table. Where I will see sum in range 0.1. In screen I have filtered only two Materials, but I have it more. In Headers of columns are my used formulas.Capture.JPG

1 Solution

Accepted Solutions

Re: Sum in class table

May be one of these as your dimension

1)

Aggr(Class([Total Stock]/[Psc Per pa]), 0.1), Edate, Material)

2)

Aggr(Class(Sum([Total Stock]/[Psc Per pa])), 0.1), Material)

2 Replies

Re: Sum in class table

May be one of these as your dimension

1)

Aggr(Class([Total Stock]/[Psc Per pa]), 0.1), Edate, Material)

2)

Aggr(Class(Sum([Total Stock]/[Psc Per pa])), 0.1), Material)

alakazam
New Contributor III

Re: Sum in class table

Sunny, you are genius! Thank you. Point 2 work.

Community Browser