Diff Tables

[#1]

Hi there,

I have 2 tables that includes 2 different date formats. I would like to join and then show it in line chart..Let me make it clear ..

TABLE 1

DATE_ID:    COUNT_CUSTOMER

01/01/2014        100

TABLE 2:

DATE_ID:                        AMOUNT

01/01/201 01:15 PM          30

I want to do format changing and calculation of second table DATE_ID in qlikview edit script. The client want to see line chart and see the total number of customer and total amount for per day...

If you reply me I would be apprecaited in you..

Kind Regards.

[marcus_sommer]

Try this:

floor(DATE_ID) - it removed the hours, minutes ...

- Marcus

[Gysbert_Wassenaar]

TABLE1:

Load date#(DATE_ID,'DD/MM/YYYY') as DATE_ID, COUNT_CUSTOMER

From ...etc

join (TABLE_1)

Load date(floor(timestamp#(DATE_ID,'DD/MM/YYYY'),'DD/MM/YYYY') as DATE_ID, AMOUNT

From ...etc

[maxgro]

i think you have to convert the date when you load it from the second table using the following format

join ([TABLE 1])

LOAD

     date#(DATE_ID, 'DD/MM/YYYY hh:mm TT') as DATE_ID,

     AMOUNT

FROM

     .....your source for table 2

     ;