topic Re: Linking Two Dates in QlikView

Linking Two Dates

NavinReddy — Wed, 29 May 2013 11:59:02 GMT

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

Re: Linking Two Dates

sushil353 — Wed, 29 May 2013 12:01:45 GMT

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

Re: Linking Two Dates

alexandros17 — Wed, 29 May 2013 12:02:16 GMT

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

Re: Linking Two Dates

NavinReddy — Wed, 29 May 2013 12:09:38 GMT

Hi,

Dates are different

I want know about sales in date wise production

then how can i link tables

Thanks

Niranjan

Re: Linking Two Dates

er_mohit — Wed, 29 May 2013 12:11:04 GMT

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

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;

Timereg:

LOAD PAYCODE ,

DATE(DateOFFICE)AS DATEOFFICE from xxx;

Office:

LOAD CARDNO

DATE(FLOOR(OFFICEPUNCH)) AS DATEOFFICE

from yy;

hope it helps

Re: Linking Two Dates

stevedark — Wed, 29 May 2013 12:16:18 GMT

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/

Re: Linking Two Dates

NavinReddy — Wed, 29 May 2013 12:19:35 GMT

Hi All ,

Thanks a lot for your reply its was nice explanation

any one can easily understand

Thanks & Regards

Niranjan

Re: Linking Two Dates

NavinReddy — Wed, 29 May 2013 12:25:15 GMT

Hi Steve,

We have two dates in two tables

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

Regards

Niranjan

Re: Linking Two Dates

er_mohit — Wed, 29 May 2013 12:48:21 GMT

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

Regards

Mohit