Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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