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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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

 

QFabian