Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
LOAD *
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
];
Hi,
use not exist()
Regards
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
] ;
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
LOAD *
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
];
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;
Check this expression in straight table -
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:
LOAD *
resident
First
Where not exist(Key,Par);
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.