Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Link dates

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

Re: Link dates

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

Re: Link dates

I think that wil help me! Thank you!

eddysanchez
Contributor

Re: Link dates

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

Re: Link dates

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.

Community Browser