Canonical Date in Qlik (handling multiple dates in Fact table)

This video will tell you how to handle multiple dates in fact table.
Sample data used in this application can be downloaded from below link.
drive.google.c...

[@PS-vc6ef]

ManishKuma is the master of Qlik and I don't care if others differ. Very clear, very precise and does not leave you wondering how he got to that last code. I have learned so much you sir!! Thank you!! Please post more if time allows you!

[@manishkumarkachhia1683]

Thanks for your lovely comments. This type of positive comments inspire me to make more videos. Hope you have checked the series of SECTION ACCESS.

[@PS-vc6ef]

@@manishkumarkachhia1683 You are welcome! It is always great to acknowledges such valuable videos. I will definitely check the SECTION ACCESS!

[@SravanKumarReddy-n3x]

Thank You Manish, Really i understand in a very better way about the concepts which you explained.

[@janaistalder4787]

THANK YOU SO MUCH! I have been researching connecting two dates with Qlik Sense for a week, and this is what I needed...an example. Many many thanks.

[@ArindamGhoshal_1303]

Sir Awesome Explaination
Thanks sir
*Keep posting amazing Contents🙏*

[@mrrohitians]

Hello Manish very nicely explained..keep doing this great stuff..can do something in detail about section access..

[@socomfy2904]

THIS IS ABSOLUTELY BRILLIANT

[@shaikabdulgaffar6013]

Thank you Manish Bhai...very easy to understand the logic

[@bollavinod4051]

Hi Sir, Good Morning
Really your way of explanation is very good and it was pretty much helpful to us..a big thanks for everything.

[@usharani7125]

Thanks Manish awesome vedio 👏👏
Please keep posting these type of videos….

[@farookshaik7462]

Nicely Explained. Great work

[@mohammadasifmaula3993]

Thanks Manish!! Concept cleared!

[@narband2778]

clearly explained.... Great Job....

[@bobbyfitzsimmons8241]

Thanks for the help.

[@cezarioabrantes5476]

Very good! Thank you for sharing this!!!

[@Raj-ho3ge]

Thanks for this wonderful video

[@datasenseandsensibility6345]

Really nice job! Well done!

[@sanketkondvilkar0747]

Hi @manishkumarkachhia1683 Sir, sincere gratitude for your invaluable guidance through the insightful videos! I’ve been trying to find the second part of your Canonical Date series on your channel, specifically the segment where you demonstrated using flag datetype for calculations. Could you please share that part as well? Many thanks once again for your dedication and support!

[@SauravKumar127]

Thnks.. but auto calendar concept will be great help in case of multiple dates in a table

[@anbaarasi8068]

அருமை

[@thanmayap]

Hi manish.. Can u also explain how can we create a single master calender with fields from 2 different tables ? These videos are so helpful , lucky that i got to see ur page. Thank you so much for wonderful proper explanation.

[@manishkumarkachhia1683]

I will create video on this topic soon.

[@thanmayap]

@@manishkumarkachhia1683 Thank you so much 😊

[@dhasharadhgoud6198]

is it work when we dont have any primany key. I have to create a primary key by combining 2 or 3 fields if it is mandatory to have a primary key.

[@anu5763]

Hi,
Thank you for such an amazing video, I have a question - can we associate some views on date field in qlik data model. Will this make app slow for user experience. Please share your suggestions
when we associate tables on ID's vs Date field from app response/performance point of view

[@manishkumarkachhia1683]

When you say associate views on date field means what? What type of views?

[@anu5763]

@@manishkumarkachhia1683 tables loaded at qliksense data model associated with each other on date field.

[@kavranaprogrammingtutorial5825]

Wow

[@saikripamohan6020]

I have 3 tables of which 2 (table a, table b )are associated to the third one with one column. The 2 tables(table a , table b) have date columns. If I try to add a canonical date table , I am getting circular reference error.

[@sameerulhaq4066]

what if I want to do with Year and I have two tables containing two dates with different name but I want to link them based on the year

[@vinodjadhav7334]

Hi Sir. Thanks for the video, Pls send me your Udemy course link for both QlikView and QlikSense.

[@andreorla91]

If you have for the same ID different YearMonth, you will list automatically every rows associated to the single YearMonth you filtered. How to avoid this?

[@manishkumarkachhia1683]

Hi Andrea,
I don't understand your question. Please explain in detail.

[@andreorla91]

@@manishkumarkachhia1683 If I have different YearMonth (i.e. jan-2021, feb-2021, mar-2021) associated to one single ID (i.e. #123) with the formula Qlik will list automatically all said YearMonth associated to that filtered ID #123, even though if I select as canonical date jan-2021 only. It's quite hard to explain without an example, sorry

[@mkmk1356]

@@andreorla91 Difficult for me to understand what exactly you are tryin to say.

[@PS-vc6ef]

@@andreorla91 Any luck with this. It seems like wanted to know, when filtering using ID #123, the 3 YearMonth date need to be showing under this ID. Correct?

[@saikrishnakollipara9651]

Can you please explain how to change weekly data in to monthly

[@manishkumarkachhia1683]

One week could be part of two months. So in this case, I would suggest to create dates for each weeks. Now divide weekly data by 7 to convert to daily. Now create month and aggregare daily data to monthly.

[@vellatacar8592]

When ı have two tables and two measure can ı use conical date?

[@manishkumarkachhia1683]

Yes, you can

[@vellatacar8592]

@@manishkumarkachhia1683 how can I ? can you help me if i send you the qfv file? I couldn't do it unfortunately. Thank you for your interest.

[@manishkumarkachhia1683]

I am on annual leave right. Contact me after 10 days through my email [e-mail]

[@vellatacar8592]

@@manishkumarkachhia1683 thank you so much .I will email you in 10 days