10 Replies Latest reply: Jul 7, 2017 6:47 AM by Onno van Knotsenburg

# Summary Percentage Issue.

Hello,

Is there an issue in displaying Summary percentage in Qlik Nprinting 16 ?

Regards,

Sound

• ###### Re: Summary Percentage Issue.

do couple screenshots:

• what you have a s a source
• what you are dooing?
• what you are trying to achieve?

add more details (precise details - as depending on them you may have 10 different answers)  to it and we will take it from there.

cheers

Lech

• ###### Re: Summary Percentage Issue.

Using Nested Levels(USage date and few fields) I have created a pixel perfect report, Summary values are populating correctly on calculating the particular filed say for example sum(Sales)  and Sum(Profit). But when i tried to calculate the Summary percentage (if sum(sales)=0,'100%',sum(profit)/sum(sales)). the value is not populating correctly. It calculates for the last usage date level of the table instead of calculating it for whole the table.

• ###### Re: Summary Percentage Issue.

Hi,

I created a working example by following the steps:

1. Create a calculated field in the LEvles node
2. Insert the expression Iif([].Sum([Gross Profit]) != 0,  [].Sum([Gross Profit]) / [].Sum([Total Sales]), 0) Customize it to met your needs.
3. Drag and drop the calculated field into the group footer

The result is correct with the sample date I used.

Please let me know if this helps.

Best,

Ruggero

• ###### Re: Summary Percentage Issue.

Hello,

I tried the above steps. Still it is taking only the last line of the table :-( ( not the whole )

• ###### Re: Summary Percentage Issue.

Yes, the above steps are to calculate the percentage only of the last line of the table because it is the only that is necessary to be calculated. The percentage for  each detail row is already calculated in the field GP%, so you need only to drag and drop it from the Levels node into the template and to format it as you prefer.

Of course, if you prefer, you can add another calculated field to show the percentage of each row but in cases like this one, where the field is already available in the source object, I suggest to use the original field to avoid unuseful calculation during the report generation. Re-calculating it will slow down the reports production speed because.

• ###### Re: Summary Percentage Issue.

Thanks a lot :-)

• ###### Re: Summary Percentage Issue.

If not, please make clear what part of this topic you still need help with .

• ###### Re: Summary Percentage Issue.

Hello,

The answer  mentioned by Ruggero Piccoli is absolutely correct. But I couldn't see the  correct answer button anywhere in the post.

• ###### Re: Summary Percentage Issue.

As I wrote in my previous post: That button is not visible when you are using the preview in your inbox. You will have to open the actual topic for that.