Qlik Community

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: 
chriys1337
Creator II
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
JordyWegman
Partner
Partner

Hi Chriys,

See this explanation:

FormatNameDescriptionExamples
"0"Zero placeholderReplaces the zero with the corresponding digit if one is present; otherwise, zero appears in the result string.

1234.5678 ("00000") -> 01235

0.45678 ("0.00", en-US) -> 0.46

0.45678 ("0.00", fr-FR) -> 0,46
"#"Digit placeholderReplaces 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 ("#####") -> 1235

0.45678 ("#.##", en-US) -> .46

0.45678 ("#.##", fr-FR) -> ,46

 

Jordy

Climber

Work smarter, not harder

View solution in original post

2 Replies
JordyWegman
Partner
Partner

Hi Chriys,

See this explanation:

FormatNameDescriptionExamples
"0"Zero placeholderReplaces the zero with the corresponding digit if one is present; otherwise, zero appears in the result string.

1234.5678 ("00000") -> 01235

0.45678 ("0.00", en-US) -> 0.46

0.45678 ("0.00", fr-FR) -> 0,46
"#"Digit placeholderReplaces 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 ("#####") -> 1235

0.45678 ("#.##", en-US) -> .46

0.45678 ("#.##", fr-FR) -> ,46

 

Jordy

Climber

Work smarter, not harder

View solution in original post

chriys1337
Creator II
Creator II
Author

Thank you, that explains it :).