Number format in text box

Anonymous — Fri, 12 Apr 2013 18:58:00 GMT

Hi!

I have the following expression:

=NuUM(SUM({<CASES.TYPE={'INCIDENT'},CATEGORY={'INCIDENT'},CASEDATES.OPEN_TIME_NUM={'>$(=$(vToday)-1)'}>}CASES.COUNTER)
-
SUM({<CASES.TYPE={'REQUEST'},CATEGORY={'REQUEST'},CASEDATES.OPEN_TIME_NUM={'>$(=$(vToday)-1)'}>}CASES.COUNTER),'##0;(##0)')

This works fine, but I want to change the number format.

In case the result is a positive number I want a minus symbol in front of the positive number . For example: - 76.

In case the result is a negative number I want a plus symbol in front of the negative number. For example + 81

Is this possible? I have tried to change the format, but have not succeeded in getting the result I want.

Best regards

Torunn

Re: Number format in text box

Fri, 12 Apr 2013 19:46:13 GMT

Hello,

Try using a conditional and concaternar information with '+' & field or '-' & Field.

Rebeca

Re: Number format in text box

Anonymous — Fri, 12 Apr 2013 21:40:22 GMT

Thank's for the reply!

I shall try your proposed solution.

Best regards

Torunn

topic Re: Number format in text box in QlikView

Number format in text box

Re: Number format in text box

Re: Number format in text box