Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

NPrinting 18 Pixel Perfect Currency Null

Hi,

I am giving currency format (format string {0:#,# €}) to different expressions. The thing is that once the format is given, for the registers without data, the € symbols shouldn't appear and is showing. How could I avoid displaying the € for the values without data?

Captura.PNG

 

Thank you.

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Re: NPrinting 18 Pixel Perfect Currency Null

At the end I am able to delete the € by formatting the expresions like this 

if(Sum(Expression)='0','',Sum(Expression))

and using the format string of nprinting designer as I was using ({0:#,# €}).

I was expecting to avoid modifying the expressions but it seems to be the best option.

Captura.PNG

View solution in original post

6 Replies
Highlighted
Contributor
Contributor

Re: NPrinting 18 Pixel Perfect Currency Null

 

Give the number format on conditional basis like

If(Isnull(Expression), Expression without Currency,Expression with currency)

Highlighted
Master II
Master II

Re: NPrinting 18 Pixel Perfect Currency Null

alt(expressionwith currency,' ')
Learning never stops.
Highlighted
Creator III
Creator III

Re: NPrinting 18 Pixel Perfect Currency Null

give the number format in Format String?

Highlighted
Contributor
Contributor

Re: NPrinting 18 Pixel Perfect Currency Null

Give the number format like this

IF(Isnull(Sum(Sales)), Num(Sum(Sales),'#,##0'),Num(Sum(Sales),'#,##0$'))

 

Change  currency and number format as per your requirement in the above expression.

 

 

Highlighted
Creator III
Creator III

Re: NPrinting 18 Pixel Perfect Currency Null

Thanks Harshan28, However, what I am expecting is to format the numbers in the "Format String" option of NPrinting, not formatting them in the expression.
Highlighted
Creator III
Creator III

Re: NPrinting 18 Pixel Perfect Currency Null

At the end I am able to delete the € by formatting the expresions like this 

if(Sum(Expression)='0','',Sum(Expression))

and using the format string of nprinting designer as I was using ({0:#,# €}).

I was expecting to avoid modifying the expressions but it seems to be the best option.

Captura.PNG

View solution in original post