# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for
Did you mean:
Contributor

## Upload from Excel without leading zero

Hello everyone,

I want to import data from excel via the  Data Editor. The field in Excel is in a standard format.. In Order to get the proper key in Qlik Sense I just need the 3 digits on the right side (right,3) but without leading zeros. So that for example  "ET/WKM/058" shows up like "58".

1 Solution

Accepted Solutions
Partner - Specialist III

Lets say you have this data:

[

Data

ET/WKM/058

ET/WKM/050

ET/WKM/58

]

If you do the following

num(subfield(Data,'/',SubStringCount(Data,'/')+1)) as Teste,

Data;

[

Data

ET/WKM/058

ET/WKM/050

ET/WKM/58

]

You`ll get

Teste Data
50ET/WKM/050
58ET/WKM/058
58ET/WKM/58

As an explanation of the formula

SubStringCount(Data,'/')+1): will get the last slash "/" position

subfield(Data,'/',SubStringCount(Data,'/')+1): will get the number part, by getting the last slash "/" caracter

num(subfield(Data,'/',SubStringCount(Data,'/')+1)): transform it into the number version, so 058 will get 58

hope it helps.

3 Replies
Partner - Specialist III

Lets say you have this data:

[

Data

ET/WKM/058

ET/WKM/050

ET/WKM/58

]

If you do the following

num(subfield(Data,'/',SubStringCount(Data,'/')+1)) as Teste,

Data;

[

Data

ET/WKM/058

ET/WKM/050

ET/WKM/58

]

You`ll get

Teste Data
50ET/WKM/050
58ET/WKM/058
58ET/WKM/58

As an explanation of the formula

SubStringCount(Data,'/')+1): will get the last slash "/" position

subfield(Data,'/',SubStringCount(Data,'/')+1): will get the number part, by getting the last slash "/" caracter

num(subfield(Data,'/',SubStringCount(Data,'/')+1)): transform it into the number version, so 058 will get 58

hope it helps.

Contributor
Author

Excellent. This works fine Thanks for your help Felip.

Partner - Specialist III

No problem, glad it helped .

Community Browser