abhaysingh
Specialist II
2015-08-18
06:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
LogicHelp
Hi guys,
I have one field in which values are
Field1
000234
.345
2356
9876
000012
Field 2
234
.345
2356
9876
12
Required Output
234
.345
2356
9876
12
Pls help
Regards
Abhay
- Tags:
- new_to_qlikview
730 Views
7 Replies
pokassov
Specialist
2015-08-18
06:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Evaluate?
643 Views
Peter_Cammaert
Partner - Champion III
2015-08-18
06:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Load all fields with
num(num#(DataField), '#.###', '.')
643 Views
Not applicable
2015-08-18
06:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Finally the output is field2?
643 Views
Kushal_Chawda
MVP
2015-08-18
06:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Simply do num(Field1)
or
purgechar(Field1,'0')
643 Views
ashwanin
Specialist
2015-08-18
07:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i think this is what you required.
643 Views
ganeshreddy
Creator III
2015-08-18
07:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Abhay,
I think you need to apply purgechar logic which Kush has mentioned above. for reference go through attached file.
Cheers,
Ganesh
643 Views
qlikviewwizard
Master II
2015-08-18
10:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Abhay, did you able to manage to get the solution, please? Thank you.
643 Views