Hi,
About totals and subtotals in PixelPerfect reports you can check https://www.youtube.com/watch?v=kR9K04RFX8o
To implement the formula you mentioned you can use scripting as show in Using scripts in a PixelPerfect report - Qlik NPrinting - YouTube
If you are not a developer, you should ask the help of one.
The C# script that you see in the video is the following:
private double topNTotalSales = 0; //topNRow rows total of sales
private double topNTotalMargin = 0; //topNRow rows total of sales
private int topRowCountTotalSales = 0; //show only first topNRow rows
//Reset the variables
private void OnSummaryResetTotalSales(object sender, System.EventArgs e) {
topNTotalSales = 0;
topRowCountTotalSales = 0;
topNTotalMargin = 0;
}
//This function is executed one time for each of the first topNRows. Each time the function is executed, it adds the value of the row to the variables used to calculate the totals of sales and margins.
private void OnSummaryRowChangedTotalSales(object sender, System.EventArgs e) {
if(topRowCountTotalSales < topNRow){
//Retrieves the value of the sales field for each row
//NPPsJt is the Qlik Sense column name
topNTotalSales += (double)DetailReport.GetCurrentColumnValue("NPPsJt");
//Retrieves the value of the sales field for each row and multiplies it by the margin in percentage to calculate the absolute margin
topNTotalMargin += (double)DetailReport.GetCurrentColumnValue("NPPsJt") * (double)DetailReport.GetCurrentColumnValue("DBUzjm");
//Add 1 to the row number counter
topRowCountTotalSales += 1;
}
}
//Returns the total of sales
private void OnSummaryGetResultTotalSales(object sender, SummaryGetResultEventArgs e) {
e.Result = topNTotalSales;
e.Handled = true;
}
//Calculates and returns the margin in percentage
private void OnSummaryGetResultTotalMargin(object sender, SummaryGetResultEventArgs e) {
e.Result = topNTotalSales != 0 ? topNTotalMargin / topNTotalSales : 0;
e.Handled = true;
}
Of course, you need to customize it to met your case, the source fields, for example, are different.
Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
