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: 
ReneeWu
Contributor
Contributor

Combine two table use common date in one chart

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 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

 

ReneeWu_0-1605774454826.pngReneeWu_1-1605774474513.png

 

Labels (1)
2 Replies
Chanty4u
Champion III
Champion III

ReneeWu
Contributor
Contributor
Author

Hello,

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

ReneeWu_0-1605835502055.png