topic How do I refer a sum function to the dimension category instead of the measure? in App Development

How do I refer a sum function to the dimension category instead of the measure?

AidaAR — Tue, 10 Oct 2023 11:59:32 GMT

Hello all,

I've just started working with Qlik sense and I've encountered something I don't know how to express properly. I have some defects I need to show depending on the group that have done them. When totalizing the number is correct and gets to the value (expresion is= sum(weight of defect)/sum(weight))

But when applying the type of defect on the grafh on the right, instead of dividing the defect by the weigh of all material processed by gruop A, it divides by the weight of the material with that defect, so the total number is now incorrect.

How can I fix this? I've tried sum all, sum total and it does not work.

It's driving me crazy

Re: How do I refer a sum function to the dimension category instead of the measure?

Mark_Little — Tue, 10 Oct 2023 12:14:24 GMT

Hi.

Take a look ay the Total Function,

https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/define-aggregation-scope.htm

Re: How do I refer a sum function to the dimension category instead of the measure?

WalterSansdis — Tue, 10 Oct 2023 15:43:35 GMT

Amigo, acho que posso te ajudar. Pra isso, você poderia disponibilizar a tabela com os campos? Seria mais fácil de entender, assim posso sugerir um filtro no próprio código da expressão. Caso não puder disponibilizar, poderia construir uma tabela de dados, parecida com a original, apenas com dados fictícios?