topic Re: exclusion help in QlikView

exclusion help

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

i have a table in my qv document which has a field called 'Location code'

the values of Location Code will be like below:

1. 0010

2. 0024

3. 0035

4. 0050

5. PR10

6. OP35

7. IT14, etc..

out of these values, i want to exclude the alphanumeric location codes i.e.,

5. PR10

6. OP35

7. IT14

How can i do this. Please help.

MK_QSL — Fri, 01 Apr 2016 13:49:35 GMT

Data:

Load

Inline

[

NO, Location Code

1, 0010

2, 0024

3, 0035

4, 0050

5, PR10

6, OP35

7, IT14

] Where IsNum([Location Code]);

Fri, 01 Apr 2016 13:59:48 GMT

thank you so much