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
    [C:\Users\kumarv\Desktop\data1.xls]
    (
    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
    [C:\Users\kumarv\Desktop\data2.xls]
    (
    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