Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Link dates

I am sure this is very easy but I can not find how to do it(or do i not use the right keywords for search)

I have two date fields in different date sets, YYYYMM of the month in which goods are bought and YYYYMM of the month in which goods are sold.

obviously i want the profit margin in this period. For my business i have no use to select a different months for one of these categories and it doesn't mather which goods are sold in which period.

So i need Qlickview to select the other YYYYMM automaticly when the first YYYYMM is selected.

How can I make this happen? It is impossible to fit them together in one dataset.

Thanks in advance!

1 Solution

Accepted Solutions
Gysbert_Wassenaar

4 Replies
Gysbert_Wassenaar

Do you want one master calendar for several date fields? Or select a value in one field and automatically select a value in another field


talk is cheap, supply exceeds demand
Not applicable
Author

I think that wil help me! Thank you!

eddysanchez
Partner - Creator
Partner - Creator

You need to create the relationship between boughtdate and solddate in a table.

If you don't know how do it, send the structure of your tables

Not applicable
Author

I tried to link the both by using

boughtdate as solddate

but it gave me a loop error. Would not know how to do this otherwise.