Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
cDS03900
Contributor
Contributor

Filter table on first character being a letter

I have a table with all articles in it. Due to historical reason parts start with a letter, consumables with a digit. 

I now want too filter for further calculations with a button all parts, so articles starting with a letter out of this table.

I have for the moment no clue how to do this, in Excel I would simply write "> a"

1 Solution

Accepted Solutions
Taoufiq_Zarra

OK

Data:
LOAD * INLINE [
    Article, Qty
    A0001, 1
    A0002, 2
    C3333, 4
    44444, 5
    Z0002, 6
    D22255, 7
    12345, 8
]where IsText(left(Article,1));

 

add where IsText(left(Article,1))

 

output :

Taoufiq_ZARRA_0-1592999213232.png

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

5 Replies
Taoufiq_Zarra

can you share a sample Data with the expected output ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
cDS03900
Contributor
Contributor
Author

I added a screenshot of a sample table how it looks and how it would need to look after filtering.

 

Taoufiq_Zarra

OK

Data:
LOAD * INLINE [
    Article, Qty
    A0001, 1
    A0002, 2
    C3333, 4
    44444, 5
    Z0002, 6
    D22255, 7
    12345, 8
]where IsText(left(Article,1));

 

add where IsText(left(Article,1))

 

output :

Taoufiq_ZARRA_0-1592999213232.png

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Saravanan_Desingh

One more solution.

tab1:
LOAD * INLINE [
    Article, Qty
    A0001, 1
    A0002, 2
    C3333, 4
    44444, 5
    Z0002, 6
    D22255, 7
    12345, 8
]
Where Not IsNum(Left(Article,1));
Saravanan_Desingh

One more version.

tab1:
LOAD * INLINE [
    Article, Qty
    A0001, 1
    A0002, 2
    C3333, 4
    44444, 5
    Z0002, 6
    D22255, 7
    12345, 8
]
Where Lower(Left(Article,1))<>Upper(Left(Article,1));