After import raw number to QV , How to make value move to right ?

[#1]

Hi All

After read raw data into QV , the value move to left side. ( wrong )

it there a way to foce it move to right ?

have try all diff methode still not work :-

trim([Price(Euros)]) as LIST_PRICE2,

num(trim([Price(Euros)])) as LIST_PRICE3,

round([Price(Euros)],0.01) as LIST_PRICE4,

Paul

[#2]

Hi All

Since this case is not so simple , enclosed the raw data if you need to test.

[tresesco]

PFA

When it is text - alignment is left (by default)

When it is number - alignment is right (by default)

[#4]

Hi Paul,

If it is just the alignment you wanted to correct, you can do so by setting the proper aligment properties at Presentation tab of properties window

Regards,

Rajesh

[#5]

Hi Paul,

By default the alignment in qlikview works as :

If it is number : Right

If it is Text : Left

In your case, you can just change the alignment in presentation tab as follows:

Also, PFA.

Hope this helps!

[#6]

Hi Tres & All other reply to my post.

Sorry for not able to explain to all of you clearly on my first post.

Thank you very much for all your offer.

But what i need is i want to make the field LIST_PRICE ,  able to display all value on the table , with out adding any code . as LIST_PRICE is link to another field that is :-

LAND_COST_TDS_SGD

And this field is from prtial reload script :-

    ROUND(LIST_PRICE*(1-Discount)*$(TRANSPORT_SG)*$(EURO_SGD),0.01) as LAND_COST_TDS_SGD

Notice that LIST_PRICE is use in above expression.

Now  LAND_COST_TDS_SGD field will not display any value when LIST_PRICE is display on the right side.

what i mean is at the end , my table will not have column LIST_PRICE.

next post i will post the qvw doc.

which i add LAND_COST_TDS_SGD . now you should understand better.

Paul

[#7]

Hi All

Enclosed my QV doc

So the solution i need is make the LIST_PRICE transform into a filed that able to display the value on the right . By add trim , round , num on LIST_PRICE.

Then use the filed which is correct 100% number , to appliy into partial reload expression.

Hope some one can advise me.

Paul

[#8 · Accepted solution]

Hi All

I found the solution :-

KeepChar([Price(Euros)],'1234567890.') as [LIST_PRICE],

I think it should work.

Thank you very much.

Paul

[nizamsha]

PFA