Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
reporting_neu
Creator III
Creator III

How do I get TOP 10 of two formulas?

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?

1 Reply
QFabian
MVP
MVP

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

 

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.