Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
dmohanty
Partner - Specialist
Partner - Specialist
‎2014-10-30 03:28 AM

Common Calendar based on Customer Start Date and End Date


Hi All,

Can someone please help me in creating a Common Calendar based on the 2 fields: Cust_Start_Date and Cust_End_Date?

The sample data has been provided below:

rankcntscv_customer_idproduct_system_codecontract_skcontract_keycontract_iddisplay_contract_idaccount_class_codeaccount_class_descproduct_keyproduct_codecust_start_datecust_end_datecontract_start_datecontract_end_datecontract_status_codesmsf_indpractice_idadviser_idcust_seg_codecust_seg_descdobnew_cust_flagexisting_cust_flaglost_cust_flag
131288FDA2374468933603353D310193081D310193081ATPSuper Allocated pension112FTL8/10/201212/31/300010/10/201212/31/3000A High Net WorthHigh Net Worth7/18/1960100
231288FDA2374468933603353D310193081D310193081ATPSuper Allocated pension112FTL8/10/201212/31/300010/10/201212/31/3000A High Net WorthHigh Net Worth7/18/1960010
331288BK2689047143235323101087880101087880NANA105ER8/10/201212/31/30001/4/201312/31/3000A High Net WorthHigh Net Worth7/18/1960010
121731US34283985141727412957330065957330065NANA105ER4/7/201112/31/30004/4/201412/31/3000A AffluentAffluent11/26/1948100
221731US34283985141727412957330065957330065NANA125IBP4/7/201112/31/30004/4/201412/31/3000PN AffluentAffluent11/26/1948010
121858US33753575114213954d358621d358621SAUAccumilation Unitised206419IBP11/27/201312/31/300012/1/20135/31/2014C AffluentAffluent5/5/1954100
221858US33753575114213954d358621d358621SAUAccumilation Unitised206419FCI11/27/201312/31/300012/1/201312/31/3000A AffluentAffluent5/5/1954010
121734CM3054422623467888D3FDHJ86544D3FDHJ86544SAUAccumilation Unitised3456123DSC6/29/200010/4/20118/15/20035/5/2004C MASS CUSTOMERMASS CUSTOMER12/27/1975100
221734CM3106765464328889LMPDH543LMPDH543SAUAccumilation Unitised3456123DWR6/29/200010/4/20115/5/20046/5/2006C MASS CUSTOMERMASS CUSTOMER12/27/1975001
253 Views
0 Likes
2 Replies
Not applicable
‎2014-10-30 03:33 AM

Hi,

Create a calender based on cust_startdate only bcoz end date is after start date only.here you can create a master calender with the following cust_startdate

Creating A Master Calendar

169 Views
0 Likes
dmohanty
Partner - Specialist
Partner - Specialist
‎2014-10-31 06:03 AM
Author

In response to

Thank you Rakesh.

Infact I need the End Date into considerations as well. Why because, I have some KPIs like Total New Customers (from start date field), Total Lost Customers (from end date field) etc.

So the end date is needed to create master calendar to have them used in the KPIs.

Any more suggestions please in the scripting?

Regards!

169 Views
0 Likes