Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
techvarun
Valued Contributor 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