Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Need to consider Numeric values after an Alphabet in my straight table or pivot for

Hi Guys,

I am having a column called "Station" which contains value as below:

Station
R01
R98
UPS
LUX
AAH
RGB
RT1
R97
R12
R34

 

Now I want to fetch the values with alphabet starts with 'R' along with numeric values after it  like 

output:

Station
R01
R98
R97
R12
R34

 

May thanks in advance!!

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Try this?

If(Left(String,1)='R' and IsNum(Mid(String,2)), String) as Output

View solution in original post

9 Replies
Highlighted
Partner
Partner

Hope this can help you.

Table_A:

Load*

From XXX

where wildmatch(Station,'R*');

 

Highlighted
Contributor III
Contributor III

Hi Reon,

this will return RGB and RT1 as well.

Output as below :
Station
RGB
RT1
R01
R98
R97
R12
R34

Highlighted
Creator
Creator

You can modify Reon given example by:

Table_A:

Load*

From XXX

where wildmatch(Station,'R0*','R1*','R2*','R3*','R4*','R5*','R6*','R7*','R8*','R9*');

Hope this helps you.
Contributor III
Contributor III

Thanks Edvin!!

 

Its working fine but it will consider the fields like as below

R2T,

R9U etc

I need values after R in numeric only. if you know any solution then please let me know.

Highlighted
MVP
MVP

Try this?

If(Left(String,1)='R' and IsNum(Mid(String,2)), String) as Output

View solution in original post

Highlighted
Partner
Partner

You can try this below.

Table_A:

Load*

From XXX

where wildmatch(Station,'R*') and IsNum(Mid(Station,2));

Highlighted
Contributor III
Contributor III

Thank you so much Tresesco!

It works absolutely fine.

Highlighted
Community Manager
Community Manager

@nikita23  I know you received your answer but I would still like to move this into the correct product forum.  Are you using QlikView? I just want to confirm before I move this. Thanks 

Sue Macaluso
Highlighted
Contributor III
Contributor III

Hi,

 

I am using QlikSense.