topic Re: Join IF in QlikView

Join IF

Anonymous — Sun, 18 Dec 2016 19:18:40 GMT

Hi All

Just wondering is there a way i can join data based on condition?

For Example i have Sales Table and Account info

I need

Load * From Sales

Left Join

Load * From Account

If accountdate > salesdate

I tried this and it does not work any ideas how to do this?

Thanks

vinieme12 — Sun, 18 Dec 2016 19:48:31 GMT

No you can't do that but you can do the below

After joining only keep records that match your criteria

Temp:

Load * From Sales

Left Join

Load * From Account

;

Noconcatenate

Fact:

Load *

Resident Temp

Where accountdate > salesdate;

Drop table Temp;