Help with linking multiple dates

[hopkinsc]

Hi all,

i need help to create a calendar linking on multiple dates.

i have 2 fact tables that have been concatenated into 1. the first one (Data1) needs to link on an 'Date Invite Sent' field but the 2nd one (Data2) needs to link on an 'End Date' field.

what i want is for a user to select a date , lets say 'Year' = 2017.

then a chart to display the sum(Value) for data1 for 2017 based on Date Invite Sent and then another row showing the Sum(Value) for Data2 for 2017 based on EndDate.

i have attached an example.

for my example, the results i am looking for is the following..

Year	DateType	Value
2017	Data1	39
2017	Data2	10

any help would be appreciated.

[sunny_talwar]

Something like this?

New Data model

[hopkinsc]

Hi Sunny,

Will the link on RowNo work in my real data? i don't understand how we can link a date using the  RowNo..

[sunny_talwar]

I had to create RowNo because there was no unique identifier in the sample. If you have a unique identifier in your table... you don't really need RowNo....

[hopkinsc]

No, the data is different, they contain some of the same fields, but there is no link between the data sets. so rowno could be used then in this case?

[sunny_talwar]

I believe so... give it a shot and see if it works or not

[hopkinsc]

‌Thanks sunny. I’ve asked a colleague to test it.

II’ve got another question on if you fancy taking a look

https://community.qlik.com/message/1453597?et=watches.email.thread#1453597

[sunny_talwar]

Mind has stopped working for today... if this is pending again tomorrow... I promise to take a look (you just need to remind me)

[hopkinsc]

‌haha thanks sunny! Much appreciated! Have a good evening.

[hopkinsc]

Reminder for Sunny