topic Re: realigning num and string combination format in QlikView

realigning num and string combination format

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I am trying to readjust the format of my expression in a straight table to have first the number the the Country in a nice realignment:

LOAD * INLINE [

Name, Country, Score

Mark, France, 200000000

John, France, 190000000000

Claudia, France, 1200

Marcus, England, 50000000

Berta, Austria, 1500000000

];

Thank you,

Raphael

Re: realigning num and string combination format

HirisH_V7 — Wed, 15 Nov 2017 12:02:22 GMT

Hi,

Go to -> Presentation -> select your expression ->Data Text -> Right Alignment

PFA

Hirish

Re: realigning num and string combination format

Anil_Babu_Samineni — Wed, 15 Nov 2017 12:03:29 GMT

PFA

Re: realigning num and string combination format

Anonymous — Wed, 15 Nov 2017 12:10:02 GMT

Almost there , but if my Countries name are not same lenght - for example England in the example I gave or in new example USA and Australia - it is not aligned - so guess need on top some kind of function, please see example of issue using your solution:

Re: realigning num and string combination format

sunny_talwar — Wed, 15 Nov 2017 12:17:05 GMT

You can get this....

1) use this expression

num(Score ,'#,##0') & Repeat(' ', Max(TOTAL Len(Country)) + 2 - Len(Country)) & '(' & Country &')'

2) Use monocode font (i used Courier New), but feel free to pick another one... here is the list List of monospaced typefaces - Wikipedia

Re: realigning num and string combination format

Anonymous — Wed, 15 Nov 2017 12:18:21 GMT

Perfect, many thanks