Solved: Dates in different tables - Qlik Community - 1764140

Skip to main content

Qlik.com | Qlik Help | Resources

Ask a Question

I have some tables with same date format, but linked on another field.

I.E., Sales, delivers and orders linked on bills.

I want to filter by dates, but I need to link on bills to trace the sales.

How can I do that?

1 Solution

Accepted Solutions

Hi @NelsonDiazDean01

Try like below

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

https://community.qlik.com/t5/QlikView-Documents/Linking-to-two-or-more-dates/ta-p/1495322

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

3 Replies

Hi @NelsonDiazDean01

Try like below

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

https://community.qlik.com/t5/QlikView-Documents/Linking-to-two-or-more-dates/ta-p/1495322

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

use the concept of link table and master calendar.

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Author

That is the subject what I am looking for