Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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!!