topic Re: Nprinting Number Format doesn't work (Expression default) in Qlik NPrinting

Nprinting Number Format doesn't work (Expression default)

Anonymous — Wed, 09 Nov 2016 19:42:54 GMT

Hi All,

I have written an expression in Qlikview which works right if the expression is set to default.

But, When I set the Number format as Expression default in the QV, The Nprinting report shows as Zero.

Can I get the Same number format in the Nprinting when I Call the QV object as a straight table

and use the columns as dimensions in Nprinting ?

Or Is there a Workaround for the Numbers to be displayed correctly??

Expression used in QV is if($(vShow) = 0, '#,##0;(#,##0)', '#,##0.0;(#,##0.0)')

where vShow is a Button.

Thanks,

harishkumarg — Thu, 10 Nov 2016 10:51:41 GMT

Is it possible to share the QVW.

Regards

Harish

vardhancse — Thu, 10 Nov 2016 10:53:20 GMT

When calling from variable, Once try to import Variable as well into the N Printing report

Anonymous — Thu, 10 Nov 2016 14:15:50 GMT

Hi Sasi,

I tried adding the variable but It does'nt work!

Thanks,

Anonymous — Thu, 10 Nov 2016 14:29:56 GMT

Harish, I dont think I can share the QVW. Is there any information you would require!

Thanks,

vardhancse — Fri, 11 Nov 2016 03:02:45 GMT

Hi,

After importing variable, once can please refresh.

or else

Once try to use expression in the chart instead of Variable.

Once again import the object and now try to get the report

Anonymous — Mon, 14 Nov 2016 16:05:05 GMT

I have tried both the methods, but it doesn't work.

I am still not able to get the number in the N-Printing as shown in the QlikView. (Expression Default)

Is there any work around??

Thanks,