Linking Two Dates

[NavinReddy]

Hi All,

i have a query could some one help me

Table1:

Sales,

Date from xx;

Table2:

Production,

Date from yy;

Is it possible to linking two dates some one help me

Thanks & Regards

Niranjan

[sushil353]

if the field name is same then it will automaticaly linked.

[alexandros17]

Dates are yet associated in QlikView, but what is the relation between Sales and production?

If you need the sales done in the same date of production, this is automatically realized by association in qlikview, otherwise you can perform a join between the tables

let me know

[NavinReddy]

Hi,

Dates are different

I want know about sales in date wise production

then how can i link tables

Thanks

Niranjan

[er_mohit]

Yeah but make sure that there's format would be same

like

Table1:

Sales,

  Date(Date#(Date,'DD-MM-YYYY'),'DD-MM-YYYY') as TempDate from xx;

Table2:

Production,

Date(floor(Date#(Date,'DD-MM-YYYY'),'DD-MM-YYYY')) as TempDate

from yy;

or

Like

Timereg:

LOAD  PAYCODE  ,

DATE(DateOFFICE)AS DATEOFFICE from xxx;

Office:

LOAD CARDNO

     DATE(FLOOR(OFFICEPUNCH)) AS DATEOFFICE

from yy;

hope it helps

[stevedark]

Hi there,

The format here is not actually relevant to whether the dates join or not - as it is the numeric representation of the date that is essential for the association to work.  It is however a good idea to have a consistent format for your dates anyway.

What will be critcal for the association is that the dates themselves are identical - ie. they don't have time portions that don't match.  The DayStart function is good for that (or the Floor function as you have in your example).

Regards,

Steve

http://www.quickintelligence.co.uk/

[NavinReddy]

Hi All ,

Thanks a lot for your reply its was nice explanation

any one can easily understand

Thanks & Regards

Niranjan

[NavinReddy]

Hi Steve,

We have two dates in two tables

i need to be disply sales in date wise production using two dates

Regards

Niranjan

[er_mohit]

if your probleem resolved then mark it either correct or helpful answer so that it might be helpful for other developer

Regards

Mohit