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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
jeanful
Partner - Contributor III
Partner - Contributor III

Template Report Suppressing Group Footer

Hi, I have a Qlik Sense Template Report working with levels. I set nested levels of detailreport sections, each of them equipped with groupheader and groupfooter.

In the most nested deteailreport section, I would like to hide the related group footer only if the detail report contains just one row (one item). I triied with the following formula in the visible property but it doesn't work: Iif( sumCount( [Consumo Gas] ) > 1, True , False ) 

How can I achieve this?

Thanks!

Labels (1)
2 Replies
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi @jeanful 

I normally test my answers but I am not able to at the moment so please take this one with grain of salt....

Have you included an object in footer which drives visibility of that group footer? Assume you create a variable with the formula you have and you include that variable in the footer (later you can hide it but it needs to be present in it). I am giving you this hint based on previous NPrinting reports which require conditional calculation object to be inside of the band you want to conditionally show or hide.

cheers

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
jeanful
Partner - Contributor III
Partner - Contributor III
Author

Hello, thank you so much for your reply, very appreciated.

I do not know NPrinting... so, when you suggest creating a variable, do you mean a general one at report level? Or do you mean a section-scope variabile? If the first one, I don't understand how it could help. If the second one, I don't how to create it in Qlik Sense Cloud Template Reports.

Thank you!!