Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cartesian join under condition

Dear Community,

I would like to create a table, which is a result of cartesian join of two tables under specific condition.

Let's say my SQL code looks like:

select a.OFFER_ST,a.OFFER_END, 
          b.MONTH_ST, b.MONTH_END, b.MONTH    
  from CP a, CP_K b
  where (a.START_CA between b. MONTH_ST and b.MONTH_END) or (b. MONTH_ST between a.START_CA and a.END_CA);

Is it possible to do this in Qlikview in a similar way?

Thank you for your help in advance!

0 Replies