topic Re: Diff Tables in QlikView

Diff Tables

Tue, 04 Feb 2014 09:53:23 GMT

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.

Re: Diff Tables

marcus_sommer — Tue, 04 Feb 2014 10:02:52 GMT

Try this:

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

- Marcus

Re: Diff Tables

Gysbert_Wassenaar — Tue, 04 Feb 2014 10:03:33 GMT

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

Re: Diff Tables

maxgro — Tue, 04 Feb 2014 10:10:46 GMT

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

;