Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Highlighted
lanlizgu
Contributor 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
lanlizgu
Contributor 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

6 Replies
harshan28
New 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)

pradosh_thakur
Honored Contributor II

Re: NPrinting 18 Pixel Perfect Currency Null

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

Re: NPrinting 18 Pixel Perfect Currency Null

give the number format in Format String?

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

 

 

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