Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
techvarun
Specialist II
Specialist II

How to achieve this

Hi Experts,

I have a table like below

 

Level Account
10A123
11A245
12123
12133
12143
12153
12163
12173
12183
12193
11A456
12456
11A466
12476
8A567
9A678
10A124

If I filter the by a where clause A123 it has to check the Level 10 and I need all the numerical values between Level 10 or less than 10 as the result.

 

 

123
133
143
153
163
173
183
193
456
466
476

If I select A245 The result would be


 

123
133
143
153
163
173
183

193

0 Replies