topic Re: Number Alignment in QlikView

Number Alignment

aveeeeeee7en — Wed, 13 Aug 2014 06:19:54 GMT

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

Re: Number Alignment

tresB — Wed, 13 Aug 2014 06:32:35 GMT

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

Re: Number Alignment

aveeeeeee7en — Wed, 13 Aug 2014 06:38:50 GMT

I have done this in Single Text Box.

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

Re: Number Alignment

tresB — Wed, 13 Aug 2014 06:47:43 GMT

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

Re: Number Alignment

aveeeeeee7en — Wed, 13 Aug 2014 06:54:29 GMT

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:

Re: Number Alignment

tresB — Wed, 13 Aug 2014 07:20:23 GMT

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