Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bhaveshp90
Contributor III

Remove values which will not start with numbers

Hello, 

I have a field "Category" whose values are

1. ABC

2. DEF

3. GHI

000

ABCDEF

GHID 

 

How can I dynamically filter so that I want only fields which starts with "1. ABC", 2. DEF, ......"10. DEX" 

and remove fields that have only numbers and starts with unwanted texts (145365, ABCDEF, GHID)

 

thanks

Labels (2)
1 Solution

Accepted Solutions

Re: Remove values which will not start with numbers

So, the pattern is that it will be a number before . and text after .? May be this

Where IsNum(Trim(SubField(Category, '.', 1))) and IsText(Trim(SubField(Category, '.', 2)))
2 Replies

Re: Remove values which will not start with numbers

So, the pattern is that it will be a number before . and text after .? May be this

Where IsNum(Trim(SubField(Category, '.', 1))) and IsText(Trim(SubField(Category, '.', 2)))
bhaveshp90
Contributor III

Re: Remove values which will not start with numbers

thank you @sunny_talwar