Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Nov. 30th, Webinar! Do More With Qlik Cloud Catalog & Lineage: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
RKULKARNI4
Contributor III
Contributor III

Variable displaying

Hello Team,

 I have one field in Qlik sense report it is showing 5 digit.The below  formula i have used :

Num(Amt,'0.00###') AS "Original Currency Rate of Exchange to Currency",

But when i export into excel it is showing only 2 digit decimal 1.11.

I need to showing 5 digit like 1.11111.

Please advise .

Regards

RK

 

 

2 Replies
Chanty4u
MVP
MVP

can you try this?

Num#(Num(Amt,'0.00###'))

Gabriel
Partner - Specialist III
Partner - Specialist III

@RKULKARNI4 

Try 

NUM#(NUM(SUM( Amt),'#0,000'))