Empty Cells on group Total

[micheledenardi]

Dear all,

i've a problem on Nprinting April 2019.

I created a group footer with totals and it works fine if the summary result is not 0 (see first table below, attachment 1), otherwise if is 0 it show an empty cell, second table below. How to fix this in order to show 0 if the total result is 0 ?

[Ruggero_Piccoli · Accepted solution]

Hi,

You are working on a PixelPerfect report so you can create a formatting rule to write the 0 characters with the same color of the background. Refer to https://community.qlik.com/t5/Qlik-NPrinting-Documents/How-to-Manage-PixelPerfect-Conditional-Output...

Best Regards,

Ruggero

[micheledenardi]

Is there a way to write a character directly with the formatting rule?

Or i have to create a text box (with hide/show formatting rule associated) with that character and then overlap it to the table cell where i want that character ?

[Ruggero_Piccoli]

Hi,

No, with the formatting rule you cannot change the value of the content. 

Yes, you can overlap a text box with Visible=No by default and a formatting rule that changes Visible=Yes when the condition is met. 

Best Regards,

Ruggero

[micheledenardi]

Ok, done, it works.

Let's suppose if we have a table with 10 columns where the total of each column can be 0, we have create 10 text cells with relative formatting rules to show 0 instead an empty cell.... very twisted solution, it will be nice to have the possibility to specify a custom value if the cell is empty or basically show 0 character if the sum() is zero...

[Ruggero_Piccoli]

Hi,

I don't understand why, if the sum=0, you don't see 0 in the cell. If the sum is 0 you should see a 0 and use the formatting rules to hide it. 

Instead of using the format string {0:#,#} try with {0:0}.

Best Regards,

Ruggero

[micheledenardi]

Ruggero,

thanks again for your help.

Applying {0:0} as format string zeros appears but the thousands separatos are missing. I don't understand completely the logic of the format string but applying {0:#,0} i have zeros and also the thousands separators.