Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
brijeshvma
Partner - Creator
Partner - Creator

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
sunny_talwar

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

];

View solution in original post

7 Replies
PrashantSangle

Hi,

use not exist()

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Clever_Anjos
Employee
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

] ;

sunny_talwar

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

];

alexandros17
Partner - Champion III
Partner - Champion III

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;

Digvijay_Singh

Check this expression in straight table -

Capture.JPG

avinashelite

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);

tyagishaila
Specialist
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.