How to use Master Calendar with multiple dates fields from different tables without linking

[kabbas]

Master Calendar with multiple dates fields from different tables without linking  , i want to do this at chart level. I tried to do that by set analysis but working on single selection not multiple selection

Basically i want to achive this:

Year	Count of Policies	Premium	Claim Count	Claim Paid
2019	Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2019	Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2019	Those are Registered in this period i.e Registration Date between 01-Jan-2019 to 31-Dec-2019	Those are Paid in this period i.e Paid Date between 01-Jan-2019 to 31-Dec-2019
2020	Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2020	Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2020	Those are Registered in this period i.e Registration Date between 01-Jan-2019 to 31-Dec-2020	Those are Paid in this period i.e Paid Date between 01-Jan-2019 to 31-Dec-2020
2021	Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2021	Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2021	Those are Registered in this period i.e Registration Date between 01-Jan-2019 to 31-Dec-2021	Those are Paid in this period i.e Paid Date between 01-Jan-2019 to 31-Dec-2021
2022	Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2022	Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2022	Those are Registered in this period i.e Registration Date between 01-Jan-2019 to 31-Dec-2022	Those are Paid in this period i.e Paid Date between 01-Jan-2019 to 31-Dec-2022
2023	Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2023	Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2023	Those are Registered in this period i.e Registration Date between 01-Jan-2019 to 31-Dec-2023	Those are Paid in this period i.e Paid Date between 01-Jan-2019 to 31-Dec-2023

Sum({<Approval _YEAR = {"$(=GetFieldSelections(Calendar_Year))"}>} Premium)

or

Sum({<Approval _YEAR = {$(=Concat(DISTINCT Chr(34)&Calendar_Year&Chr(34),','))}>} Premium)

Your quick response would by helpful. 

[Rohan]

Hi,

Please check out the following link  :

https://cassio-bolba.medium.com/date-island-qlik-sense-25ea793aca2d

Thanks & Regards,

Rohan.

[Rohan]

Basically, You will create an additional Date field which is not linked to your data model, & use this field in the Set analysis to define the date ranges on your respective Date fields.

Let me know in case of any queries.

Thanks & Regards,

Rohan.

[Kushal_Chawda]

@kabbas  Check canonical date here