Showing diff data

[#1]

Hi to all qlik experts!

I have a simple question and need your help...Let me briefly explain it with sample data..My first table is

DATE_ID ,                                                                        CUSTOMER  ,                                 COUNT,

YYYYMMDDhh:mm (The date field is string)                             A                                            100

YYYYMMDDhh:mm (The date field is string)                             B                                            200

YYYYMMDDhh:mm (The date field is string)                             C                                            300

My Second Table is.:

DATE_ID ,                                                                       ORDER    ,                                 COUNT,

YYYYMMDD (The date field is string)                                       A                                            5

YYYYMMDD(The date field is string)                                        B                                            8

YYYYMMDD(The date field is string)                                        C                                            10

My client want to see two tables in a same chart such as line chart based on date_id...They mainly compare two dimension at the same date ranges..We dont wanna go back to database to fix up some date format issues or join troubles...We want to fix it on qlikview...If you give me a hand I would be appreciated in you..

Thanks for collaboration..

PS: If you send me a sample qvd that would be great for me...

[#2]

The Oscar goes to Sokhorn!  He is the most effective and helpful guy on this forum...thanks for other valuable replies as well..

[Sokkorn]

Thank you so much Mr. Atacan.

Regards,

Sokkorn