topic Re: loading conditional records from a tabel in QlikView

loading conditional records from a tabel

JACKNIEKERK — Sat, 16 Nov 2024 00:05:53 GMT

2 tabels

1 names of customers

2 sales of customers

at (re)loading the database customers now i get all customers wich exist

load
DebNum,
DebName ;
SQL SELECT * FROM DEBNAW;

even if not any sales in sales tabel:

Load
Customer as DebNum,
ItemId,
Sales as Euro;
SQL select * from SALES ;

So how to set the load statement in Customers to read only customers who have any sales in the SALES tabel

lironbaram — Sun, 23 Aug 2020 10:23:40 GMT

you can do like this

Sales:

Load
Customer as DebNum,
ItemId,
Sales as Euro;
SQL select * from SALES ;

left keep (Sales)

load
DebNum,
DebName ;
SQL SELECT * FROM DEBNAW;

JACKNIEKERK — Sun, 23 Aug 2020 10:41:29 GMT

Works fine!! Thanks