topic How to display a dash Or blank for 0 in Qlik NPrinting Pixel Perfect report in Qlik NPrinting

How to display a dash Or blank for 0 in Qlik NPrinting Pixel Perfect report

mstoler — Fri, 16 Sep 2022 09:44:23 GMT

Hello,

Are there format strings for NPrinting Pixel Perfect to display a 0 quantity as a dash (-) or blanks?

Looking for documentation on the format strings.

Thanks,

Michael

Re: pixel perfect display 0 values as a dash or blank

Frank_S — Fri, 16 Sep 2022 09:43:28 GMT

@mstoler

It might be best to manage this directly in the source application.

I found two similar solutions in the community for your convenience.

Kind regards...

Re: pixel perfect display 0 values as a dash or blank

mstoler — Fri, 14 Jan 2022 18:20:17 GMT

Hello,

Nothing like in Qlik where you can do something like below in the num function.

#,##0;-#,##0;-

Note the dash at the end.

Michael

Re: pixel perfect display 0 values as a dash or blank

Lech_Miszkiewicz — Fri, 16 Sep 2022 09:39:37 GMT

Hi Michael,

Of course, there is a way just like you said with the example in QlikView - here is the syntax: {0:#,# ;(#,#);- }

Format string to display negative numbers in parenthesis

@Frank_S - Do you think appropriate documentation could be linked in htttps://help.qlik.com? I blindly searched for DevExpress topics in this regard and I found the above link, but I think R&D would be able to point us to correct documentation in that regard which in the case of PixelPerfect would be very helpful.

This is a tested scenario which worked for me:

I used QlikView for this testing:

Pixel Perfect Template

and result:

Cheers

Lech

Re: pixel perfect display 0 values as a dash or blank

mstoler — Sat, 15 Jan 2022 10:12:41 GMT

Hello,

Perfect!

Exactly what I am looking for.

Take care,

Michael

Re: pixel perfect display 0 values as a dash or blank

Frank_S — Mon, 17 Jan 2022 15:56:52 GMT

@Ruggero_Piccoli
Can you have a look at @Lech_Miszkiewicz question above?

Re: pixel perfect display 0 values as a dash or blank

mstoler — Mon, 17 Jan 2022 16:06:53 GMT

Yes it is perfect !

Michael