Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Is there an issue in displaying Summary percentage in Qlik Nprinting 16 ?
Regards,
Sound
Please add some details.
Please add some details.
do couple screenshots:
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
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.
Screenshot attached for your reference.
Hi,
I created a working example by following the steps:
The result is correct with the sample date I used.
Please let me know if this helps.
Best,
Ruggero
Hello,
I tried the above steps. Still it is taking only the last line of the table 😞 ( not the whole )
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.
Thanks a lot 🙂
If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).
If not, please make clear what part of this topic you still need help with .
Hello,
The answer mentioned by Ruggero Piccoli is absolutely correct. But I couldn't see the correct answer button anywhere in the post.