Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ester_pr
New Contributor

Join by dates

Hi,

I want to join tables

on table have costNamber, cost and date_of_updatd

and the oter have costNamber and date_of_debit,

of cuorse the cost shuold be attached to the cost of the date that in between the date_of_updatdes

how to do it when ther is one field of date?

is it better to do so in a script or in the object?

Thank you,

Ester

1 Reply
rohit214
Contributor III

Join by dates

tab1:

load

costNamber as costNamber_tab1,

cost ,

date((date_of_updatd),'DD/MM/YYYY')  as common_date

;

tab2:

load

costNamber as costNamber_tab2,

date( date_of_debit),'DD/MM/YYYY) as common_date

;

i hope  u understand .

Thanx and Regard

rohit

Community Browser