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: 
hopkinsc
Partner
Partner

Help with linking multiple dates

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

YearDateTypeValue
2017Data139
2017Data210

any help would be appreciated.

10 Replies
sunny_talwar

Something like this?

Capture.PNG

New Data model

Capture.PNG

hopkinsc
Partner
Partner
Author

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

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

‌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
Partner
Partner
Author

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

hopkinsc
Partner
Partner
Author

Reminder for Sunny