Non-Equi Join in QlikView

[nihhalmca]

Hi All,

There is any possibility to do Non-Equi Join operation (unlike Inner) in QlikView.

I'm expecting keyword like Left join, Right join, Outer join.

Regards,

Nihhal.

[maximiliano_vel]

Yes all does keywords exists, please see help in QV Desktop

[nihhalmca]

Is it available Non-Equi Join in QlikView? For all i know there is no non-equi join in QV.

[jonathandienst]

If by non-equi join you mean a SQL join clause on an inequality( <>, <, >), then no, there no direct equivalent in QV. However, you can usually achieve it using  an extra resident load.

[nihhalmca · Accepted solution]

Thank you Jonathan.

I achieved this by these steps.

1. Outer join

2. Resident load outer join table with where key1<>key2.

Regards,

Nihhal.