topic Re: Combine two table use common date in one chart in QlikView

Combine two table use common date in one chart

ReneeWu — Fri, 15 Nov 2024 23:36:04 GMT

Hello everyone,

I want to combine Potential table with Billing table use common date in one chart.

Below chart 1 date isn't actually Billing date. How to let chart 2 in chart 1?

I look for lots of Q&A. Concatenate two table or use common date dimension is a method.

But actually between Potential and Billing have another table. And I just want to show Potential transfer to Billing data. Could you please help? Thanks in advance.

The relationship is below:

Potential:

Potential No

Potential Date

Amt

Qty

RFQ:

Potential No

RFQ Date

RFQ No

Amt

Qty

Billing:

RFQ No

Billing Date

Amt

Qty

Re: Combine two table use common date in one chart

Chanty4u — Thu, 19 Nov 2020 09:48:04 GMT

Hi,

Try to create a link date and use single date in the chat

https://community.qlik.com/t5/QlikView-Scripting/Link-2-Date-Fields-in-1-Table-to-1-Master-Calendar/td-p/84165

Re: Combine two table use common date in one chart

ReneeWu — Fri, 20 Nov 2020 01:33:08 GMT

Hello,

I don't know if I understand that exactly . If I create a link date will cause a circular reference. Thank you anyway.