Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)
Sunny, you are genius! Thank you. Point 2 work.