Not applicable
2015-07-21
05:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
need to display textual values
hi
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
- Tags:
- new_to_qlikview
428 Views
1 Solution
Accepted Solutions
tresesco
MVP
2015-07-21
05:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Load
If( Isnum(trim(YourField)), YourField) as Numeric,
If( Not Isnum(trim(YourField)), YourField) as AlphaNumeric
324 Views
3 Replies
arulsettu
Master III
2015-07-21
05:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this
KeepChar('ww12',0123456789) as number
PurgeChar('ww12',0123456789) as text
replace ww12 with your field
324 Views
tresesco
MVP
2015-07-21
05:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Load
If( Isnum(trim(YourField)), YourField) as Numeric,
If( Not Isnum(trim(YourField)), YourField) as AlphaNumeric
325 Views
Not applicable
2015-07-21
05:56 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thanks tresesco thank u so much
324 Views