Number Alignment

[aveeeeeee7en]

Hi Community

I have written below expression and using it for sending Mail Alerts. But the problem I am facing is related to the alignment of the numbers. I have tried everthing - used chr(32), spacing in num format ---- num(myexpression,'   #,##0) but no gain.

The Quantity and value on daily basis increase or decrease so, I don't know the exact length of the number. It'll keep on changing everyday.

My Result:

Quantity :  21 &    Value :  0.12 (Mn INR)

Quantity :  1,113 &    Value :  123.03 (Mn INR)

Desired Result:

Quantity :       81     &    Value :      0.12    (Mn INR)

Quantity :  5,813     &    Value :  123.03    (Mn INR)

Regards

Aviral Nag

[tresesco]

Better play with horizontal alignment (right) rather than number format.

[aveeeeeee7en]

I have done this in Single Text Box.

So, Tresesco Sir your solution won't work here.

[tresesco]

Yes, if you think multiple text boxes is an option, then you can do it easily.

[aveeeeeee7en]

I am using Qlikview Mail Functionality and it doesn't allow to send objects - charts, Text Boxes in Mail.

It has only option to send Text.

See the Snapshot:

[tresesco]

I guess that way it won't be possible. You could think of creating a report and distribute that to users.