Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
darren_dixon
Contributor III
Contributor III

Two dates into one

Hi,

I have two date fields in two seperate tables and need these to be one.

Date field 1 - "ZuesDate" in Results table.

Date field 2 - "ActualStart" in Appointments table.

Example-A shows the current table join. Using a mult-box to select a date, either by ZuesDate or ActualStart, shows no results.

Example-B  shows the ZuesDate renamed to ActualStart but causes a result. Using a mult-box to select a date, either by ZuesDate or ActualStart, shows no results.

Results Table:

Load

"I_PERSID",

Date(floor(D_DATE)) as ActualStart;

SQL SELECT *

FROM isgus.dbo."RESULTS_BASESUMS_T";

PersInfo Table:

LOAD

"I_PERSID",

"S_PERSNR" AS "Operative Number";

SQL SELECT *

FROM isgus.dbo."PERSINFO_MASTER";

FirstTouchProfiles Table:

LOAD

Value,

PropertyName,

if("PropertyName"='OptiTime_ResourceID', Value,) AS "OptitimeResourceID",

if("PropertyName"='Operative Number', Value,) AS "Operative Number";

SQL SELECT *

FROM "1stTouch_Live".Profile.UserProperties;

Appointment Table:

LOAD

OptitimeResourceID,

Date(floor(ActualStart)) as ActualStart,

SQL SELECT *

FROM MyOptiTime.dbo."tblXWR_Appointments";

Example-A

Example-A.jpg

Example-B

Example-B.jpg

Hope you can help.


Thanks,

Darren

0 Replies