Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to calculate the proportion of two parts. That's why I used the following formulas:
Sum({<[VST_CallPosition.x_Klasse] = {100}, [VST_Call.xCallart] = {12}>}VST_CallPosition.Menge)
/
Sum({<V_BelegPos_CP.V_BelegPos.BelegArt = {'R'}, [V_BelegPos_CP.V_BelegPos.ypA_gedruckt] = {1}, [V_BelegPos_CP.V_BelegPos.ypA_AuftragsArt] = {''}>}V_BelegPos_CP.V_BelegPos.Menge)
I have found various solutions for individual formulas, but not when I have to combine two formulas.
The column is to be added to a table in which the dimension is already set to TOP 10.
Menge | Vorgänge | PartNo | Part | The value still to be calculated |
5 | 1 | 100 | ABC | 50% |
100 | 522 | 103 | CBA | 20% |
8 | 10 | 521 | BAC | 18% |
18 | 90 | 189 | BCA | 19% |
Can you help me?
Hi @reporting_neu , do you know about AGGR function? maybe can help you allowing you to agrgegate aggregations
sum(sum(
https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/aggr.htm