https://community.qlik.com/t5/App-Development/Intervalmatch-default-value/m-p/1785482#M61242 <P>You can also try ApplyMap. You can pass the default values through ApplyMap.</P> Tue, 23 Feb 2021 20:30:24 GMT Saravanan_Desingh 2021-02-23T20:30:24Z https://community.qlik.com/t5/App-Development/Intervalmatch-default-value/m-p/1783942#M61101 <P>I have a table with&nbsp;the info for those employees with FTE (Full Time Equivalent) not equal to 100%.<BR /><BR />The fields are:<BR />Company - Employee - FTE - WeekDay - WorkingHours - FromDate - ToDate<BR /><BR />Using IntervalMatch() I can join these info to a calendar table, but I get data only for those employees.<BR /><BR />Is there a way to set default values for all the other employees, i.e. those with FTE = 100%, based on Company value?</P> Sat, 16 Nov 2024 00:34:27 GMT https://community.qlik.com/t5/App-Development/Intervalmatch-default-value/m-p/1783942#M61101 SergioS 2024-11-16T00:34:27Z https://community.qlik.com/t5/App-Development/Intervalmatch-default-value/m-p/1785482#M61242 <P>You can also try ApplyMap. You can pass the default values through ApplyMap.</P> Tue, 23 Feb 2021 20:30:24 GMT https://community.qlik.com/t5/App-Development/Intervalmatch-default-value/m-p/1785482#M61242 Saravanan_Desingh 2021-02-23T20:30:24Z