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.
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