Qlik Community

QlikView Documents

Documents for QlikView related information.

Where not Exists and Exits

vinay_bangari
Valued Contributor III

Where not Exists and Exits

Most of the people may know about this already or have them already . But I would like to share this content with you. I see most of the new to qlikview developers face these questions initially when they first begin their career in any BI tool or Qlikview.


Script if anyone uses personal edition:


Fiter_table:
LOAD Salesman&SalesmanName as Filter_Salesman_No,
SalesmanName as SM_name

FROM

(
biff, embedded labels, table is Sheet1$);

// The First table should be your table which records needed to be filtered . Here we have to load the Duplicate table which is given by your Business


FinalTable:
LOAD Salesman,
SalesmanName,
Qty,
[Gross Price],
[Net Price],
Cost,
Profit,
Profit%,
inputfield
FROM

(
biff, embedded labels, table is Sheet1$)

Where not Exists(Filter_Salesman_No,Salesman&SalesmanName);

///if you do exists ... then it will pull on the filtered data...

drop table Fiter_table;

// We can drop the filter table. if we do not have to drop the filter table make sure you rename all the columns present in the filter table


Attachments
Comments
Not applicable

good information

Version history
Revision #:
1 of 1
Last update:
‎08-21-2015 10:55 AM
Updated by: