topic Re: need to display textual values in QlikView

need to display textual values

Tue, 21 Jul 2015 09:41:33 GMT

i have a scenario in this i need to display numbers in one field and number+character combination in one field

1122

3344

1568

ww12

34rg

ww17

10kk

ttttt

in this i want to display 1122,3344,1568 in one field and remaining data in one field like that i have lot of data please help me to solve this problem

Re: need to display textual values

arulsettu — Tue, 21 Jul 2015 09:44:52 GMT

try this

KeepChar('ww12',0123456789) as number

PurgeChar('ww12',0123456789) as text

replace ww12 with your field

Re: need to display textual values

tresB — Tue, 21 Jul 2015 09:50:11 GMT

Load

If( Isnum(trim(YourField)), YourField) as Numeric,

If( Not Isnum(trim(YourField)), YourField) as AlphaNumeric

Re: need to display textual values

Tue, 21 Jul 2015 09:56:30 GMT

thanks tresesco thank u so much