Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
lanlizgu
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.

Labels (4)
1 Solution

Accepted Solutions
lanlizgu
Creator III
Creator III
Author

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
harshan28
Contributor
Contributor

 

Give the number format on conditional basis like

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

pradosh_thakur
Master II
Master II

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

give the number format in Format String?

harshan28
Contributor
Contributor

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.

 

 

lanlizgu
Creator III
Creator III
Author

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.
lanlizgu
Creator III
Creator III
Author

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