8 Replies Latest reply: Mar 27, 2015 4:04 PM by chaithanya nataraj RSS

    how to remove lines form right keep

      hi

      this is my code

       

       

       

       

      cust:

      LOAD [Customer ID],

           Country,

           Customer

      FROM

      [C:\Users\kamal\Desktop\Qlik View\Customer.xls]

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

       

       

      sales:

      right keep LOAD Month,

           [Salesman ID],

           [Customer ID],

           [Transaction ID],

           Year,

           Day,

           [Product ID],

           [Serial No],

           [List Price],

           Sales,

           [Gross Margin]

      FROM

      [C:\Users\kamal\Desktop\Qlik View\Sales.xlsx]

       

       

       

       

      it fetches 750 lines, i want to remove the customers who are not having any sales in the final table.