topic Re: Format Problem in QlikView

Format Problem

Fri, 27 Jul 2012 14:41:10 GMT

Hi all,

i am reading from an Excel file. Now, in a cell there can be a value 50 or 50%,#

In a chart on the surface i am representing the numbers with num(CELLVALUE, '# ##0.00').

Problem is that the 50 is correctly displayed as 50%, but the 50% is displayed as 5000.00%.

How can i avoid this in the LOAD script ?

Thanks a lot.

Fri, 27 Jul 2012 14:45:16 GMT

Num(left(FIELD,2),'#,##0.00%')

Fri, 27 Jul 2012 14:47:38 GMT

Of course i can have also values like 100% or even 1000% in there....Is there a way to read until the '%' or just read the numeric chars ?

MayilVahanan — Fri, 27 Jul 2012 14:56:17 GMT

Hi,

You can use Purgechar(FieldName,'%') as FieldName , It removes % symbol..

Hope it helps

CELAMBARASAN — Fri, 27 Jul 2012 14:56:26 GMT

Try this

Replace(CELLVALUE,'%','')&'%' AS FieldName

PurgeChar(CELLVALUE,'%')&'%' AS FieldName