Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master
‎2021-02-19 04:05 AM

Number format

Hi Folks,

i got a question. i receive the date from SAP - Environment and i have some issue with figures, for instance:

in SAP  i got this figure: 14.175 but in Qlik Sense : 141.75 (and the same problem i have with: SAP - 3.011.925 = Qlik Sense - 30.119.25). i tried to solve this issue by using of function: num#() but it does not work.

as i said, my expected output is: 14.175 and not 141.75

does anybody have any idea? Thanks a  lot

Bek

Labels (1)
Labels
370 Views
0 Likes
3 Replies
Chanty4u
MVP
MVP
‎2021-02-19 04:35 AM

not sure but try this

 

=yourfield/10   as newfield

344 Views
0 Likes
beck_bakytbek
Master
Master
‎2021-02-19 04:46 AM
Author

In response to Chanty4u

Hi Chanty4u, thanks a lor for your time and feedback, i know this option, but i use this suggestion then i dont see other numbers under 1. Mio

333 Views
0 Likes