Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sergio0592
Specialist III
Specialist III

How simply get preceding + sign

Hi all,

I'am looking for a little simple thing : in a text box id'like to add a preceding + ou - sign depends my kpi is negative or positive. I want avoid condition (if KPI > 0, '+'&KPI Value....). 

By default - sign appears when value is negative but no + when positive.

Any idea?

 

Labels (1)
1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

It could be reached just with a formatting like:

=num(YourNumber, '+ #.##0,00;- #.##,00')

- Marcus

View solution in original post

1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

It could be reached just with a formatting like:

=num(YourNumber, '+ #.##0,00;- #.##,00')

- Marcus