Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
brijeshvma
Partner
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
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.
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

];

View solution in original post

alexandros17

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
Master III
Master III

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.