topic Re: Help with linking multiple dates in QlikView

Help with linking multiple dates

hopkinsc — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Help with linking multiple dates

sunny_talwar — Thu, 15 Mar 2018 11:18:31 GMT

Something like this?

New Data model

Re: Help with linking multiple dates

hopkinsc — Thu, 15 Mar 2018 11:24:12 GMT

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

Re: Help with linking multiple dates

sunny_talwar — Thu, 15 Mar 2018 11:25:41 GMT

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

Re: Help with linking multiple dates

hopkinsc — Thu, 15 Mar 2018 11:28:01 GMT

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?

Re: Help with linking multiple dates

sunny_talwar — Thu, 15 Mar 2018 21:04:24 GMT

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

Re: Help with linking multiple dates

hopkinsc — Thu, 15 Mar 2018 21:25:44 GMT

‌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

Re: Help with linking multiple dates

sunny_talwar — Thu, 15 Mar 2018 21:27:01 GMT

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

Re: Help with linking multiple dates

hopkinsc — Thu, 15 Mar 2018 21:37:06 GMT

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

Re: Help with linking multiple dates

hopkinsc — Fri, 16 Mar 2018 11:20:55 GMT

Reminder for Sunny

Re: Help with linking multiple dates

sunny_talwar — Fri, 16 Mar 2018 11:35:11 GMT

Hahahaha looking