# New to Qlik Sense

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for
Search instead for
Did you mean:
Creator II

## Number Format using hash keys - Logic

HI,

I have a question regarding the Number Formatting:

Num( 35648, '#,##0.##')

Why are there hash keys used, just not one digit before the decimal place.

I want to understand the logic behind this, can anybody please help?

1 Solution

Accepted Solutions
Partner

Hi Chriys,

See this explanation:

 Format Name Description Examples "0" Zero placeholder Replaces the zero with the corresponding digit if one is present; otherwise, zero appears in the result string. 1234.5678 ("00000") -> 012350.45678 ("0.00", en-US) -> 0.460.45678 ("0.00", fr-FR) -> 0,46 "#" Digit placeholder Replaces the "#" symbol with the corresponding digit if one is present; otherwise, no digit appears in the result string.Note that no digit appears in the result string if the corresponding digit in the input string is a non-significant 0. For example, 0003 ("####") -> 3. 1234.5678 ("#####") -> 12350.45678 ("#.##", en-US) -> .460.45678 ("#.##", fr-FR) -> ,46

Jordy

Climber

Work smarter, not harder
2 Replies
Partner

Hi Chriys,

See this explanation:

 Format Name Description Examples "0" Zero placeholder Replaces the zero with the corresponding digit if one is present; otherwise, zero appears in the result string. 1234.5678 ("00000") -> 012350.45678 ("0.00", en-US) -> 0.460.45678 ("0.00", fr-FR) -> 0,46 "#" Digit placeholder Replaces the "#" symbol with the corresponding digit if one is present; otherwise, no digit appears in the result string.Note that no digit appears in the result string if the corresponding digit in the input string is a non-significant 0. For example, 0003 ("####") -> 3. 1234.5678 ("#####") -> 12350.45678 ("#.##", en-US) -> .460.45678 ("#.##", fr-FR) -> ,46

Jordy

Climber

Work smarter, not harder
Creator II
Author
Thank you, that explains it :).
Tags
Community Browser