Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Surya
Creator II
Creator II

Num Format Issue in Qlik

Hello Techies,

I want Number format 

If positive +7,3 else  -7.3 Please find below final format 

Surya_0-1627639908851.png

 

Labels (1)
1 Solution

Accepted Solutions
Surya
Creator II
Creator II
Author

hello All,

Thanks..Im done

'+'& replace(Num(val,###%),'.',',')

View solution in original post

5 Replies
rwunderlich

Use a format pattern like:

+0.0%;-0.0%

-Rob

Surya
Creator II
Creator II
Author

Hi Rob.

 

when im using this format 

Actaul values is +77,4 but it shows +7,7

 

-Surya

Patricia_Silva
Support
Support

Hello @Surya, would you have a sample app so I can try to test it? Thank you 🙂

Help users find answers! Don't forget to mark a correct resolution 🙂
rwunderlich

I forgot the #. And I also have trouble getting the "," as decimal separator on my US machine. But my point was that the format mask provides for both positive and negative formats. 

+#0,0%;-#0,0%

https://help.qlik.com/en-US/sense/May2021/Subsystems/Hub/Content/Sense_Hub/Introduction/conventions-...

https://qlikviewcookbook.com/2014/05/the-third-format/

 

Surya
Creator II
Creator II
Author

hello All,

Thanks..Im done

'+'& replace(Num(val,###%),'.',',')

View solution in original post