topic Re: Empty Cells on group Total in Qlik NPrinting

Empty Cells on group Total

micheledenardi — Tue, 17 Mar 2020 20:40:38 GMT

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 ?

Re: Empty Cells on group Total

Ruggero_Piccoli — Wed, 25 Sep 2019 12:24:16 GMT

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-Formats-Using-the/ta-p/1484894

Best Regards,

Ruggero

Re: Empty Cells on group Total

micheledenardi — Wed, 25 Sep 2019 13:34:18 GMT

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 ?

Re: Empty Cells on group Total

Ruggero_Piccoli — Wed, 25 Sep 2019 13:49:37 GMT

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

Re: Empty Cells on group Total

micheledenardi — Wed, 25 Sep 2019 14:12:58 GMT

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...

Re: Empty Cells on group Total

Ruggero_Piccoli — Wed, 25 Sep 2019 14:50:28 GMT

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

Re: Empty Cells on group Total

micheledenardi — Thu, 26 Sep 2019 06:46:09 GMT

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.