Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Kushal_Chawda
MVP
MVP

SQL EXCEPT in qlikview

Hi,

I have SQL query with Except statment.

SELECT column1 [, column2 ]
FROM table1
[, table2 ]
[WHERE condition]

EXCEPT

SELECT column1
[, column2 ]
FROM table1
[, table2 ]
[WHERE condition]

I want to implement same in qlikview but dont know how to achieve..

I have 5 columns in both the table

Any help would be appreciated

Regards,

Kush

Labels (1)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi,

its same as NOT EXIST in qlikview

View solution in original post

1 Reply
Anonymous
Not applicable

Hi,

its same as NOT EXIST in qlikview