topic Re: Display a string of 100 in QlikView

Display a string of 100

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

Hi Experts!

I have a field with values starting with an underscore(_) and would like to get rid of those and used the below script. =if(left(Location,1)='_',right(Location,len(Location)-1))

It takes out the underscore in most of the values but when it comes to _100, it's giving a result of 1E2.

What is the correct code to display this value a string of 100? Other values have long string.

_100

_IT DEPARTMENT

_SOUTH WING

Hoping for your help with this.

Re: Display a string of 100

Anil_Babu_Samineni — Mon, 08 Jan 2018 06:23:01 GMT

Can you share input values and output result you want to see?

Re: Display a string of 100

Chanty4u — Mon, 08 Jan 2018 06:24:57 GMT

try

am not sure your req

purgechar(Field,'_') as newLocation

Re: Display a string of 100

Prashant_N — Mon, 08 Jan 2018 06:55:40 GMT

Hi Preciosa,

As Chanty repiled just add Text(Purgechar(Field,'_')) as newLocation for converting Num to String

Hope it works.

Regards,

Prashant Naik

Re: Display a string of 100

marcus_sommer — Mon, 08 Jan 2018 08:08:26 GMT

1E2 = 100 - it's just another type of writing numbers. Try to change your expressions into:

if(left(Location,1) = '_', alt(num(mid(Location, 2)), mid(Location, 2)), Location) as LocationNew

If the underscore could only occure on the first position you could try it with the suggestion from sureshqv respectively replacing with it the mid-part in my suggestion.

- Marcus

Re: Display a string of 100

xarapre7 — Mon, 08 Jan 2018 15:20:10 GMT

Hi Prashant!

This worked. Thank you very much for your help!

Re: Display a string of 100

xarapre7 — Mon, 08 Jan 2018 15:22:31 GMT

Thanks Marcus!

I tried this and it worked!