# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for
Did you mean:
Partner

## how to do not in qlikview

Hi Everyone can any one tell me how to do Not in funtion in qlikview

Say what i want we have two table

First:

LOAD * INLINE [

Par,AFirst

1,A1

2,A2

3,A3

4,A4

5,A5

6,A6

7,A7

8,A8

9,A9

10,A10

];

Second:

LOAD * INLINE [

Par,BFirst

1,B1

2,B2

3,B3

4,B4

5,B5

6,B6

7,B7

];

Output i want:

8,A8

9,A9

10,A10

1 Solution

Accepted Solutions
MVP

Have not tested this, but may be this:

Second:

LOAD * INLINE [

Par,BFirst

1,B1

2,B2

3,B3

4,B4

5,B5

6,B6

7,B7

];

First:

NoConcatenate

Where Not Exists(Par);

LOAD * INLINE [

Par,AFirst

1,A1

2,A2

3,A3

4,A4

5,A5

6,A6

7,A7

8,A8

9,A9

10,A10

];

7 Replies

Hi,

use not exist()

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Employee
```Second:
LOAD  Par,BFirst,KeepChar(BFirst,'0123456789') as Key INLINE [
Par,BFirst
1,B1
2,B2
3,B3
4,B4
5,B5
6,B6
7,B7

];
First:
LOAD * where not exists(Key,KeepChar(AFirst,'0123456789'));
LOAD * INLINE [
Par,AFirst
1,A1
2,A2
3,A3
4,A4
5,A5
6,A6
7,A7
8,A8
9,A9
10,A10
] ;

```
MVP

Have not tested this, but may be this:

Second:

LOAD * INLINE [

Par,BFirst

1,B1

2,B2

3,B3

4,B4

5,B5

6,B6

7,B7

];

First:

NoConcatenate

Where Not Exists(Par);

LOAD * INLINE [

Par,AFirst

1,A1

2,A2

3,A3

4,A4

5,A5

6,A6

7,A7

8,A8

9,A9

10,A10

];

MVP

ALL:

LOAD * INLINE [

Par,AFirst

1,A1

2,A2

3,A3

4,A4

5,A5

6,A6

7,A7

8,A8

9,A9

10,A10

];

Join

LOAD * INLINE [

Par,BFirst

1,B1

2,B2

3,B3

4,B4

5,B5

6,B6

7,B7

];

EXCL: NoConcatenate

LOAD * Resident ALL Where IsNull(AFirst) or IsNull(BFirst);

DROP Table ALL;

Master III

Check this expression in straight table -

MVP

Try like this :

First:

LOAD * INLINE [

Par,AFirst

1,A1

2,A2

3,A3

4,A4

5,A5

6,A6

7,A7

8,A8

9,A9

10,A10

];

Second:

LOAD *,Par as Key;

LOAD * INLINE [

Par,BFirst

1,B1

2,B2

3,B3

4,B4

5,B5

6,B6

7,B7

];

Output:

resident

First

Where not exist(Key,Par);

Specialist

Second:

LOAD * INLINE [

Par,BFirst

1,B1

2,B2

3,B3

4,B4

5,B5

6,B6

7,B7

]

;

First:

LOAD * INLINE [

Par,AFirst

1,A1

2,A2

3,A3

4,A4

5,A5

6,A6

7,A7

8,A8

9,A9

10,A10

] where not Exists(Par);

and then omit rows where AFirst is Null.