topic Re: Holidays in NetworkDays for Different Countries in QlikView

Holidays in NetworkDays for Different Countries

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

By using Networkdays we can remove non business days

but i want to the same logic by using interval match() can any one help me for this logic

Anil_Babu_Samineni — Thu, 05 Jul 2018 03:56:44 GMT

Can we know, If one future is available why we are thinking second future. Is that Interview question?

Anonymous — Thu, 05 Jul 2018 08:40:27 GMT

Yes it is Interview question

Anil_Babu_Samineni — Thu, 05 Jul 2018 13:54:52 GMT

Okay

Anonymous — Fri, 06 Jul 2018 09:16:11 GMT

Did you know the logic please share Anil

Anil_Babu_Samineni — Tue, 10 Jul 2018 13:33:08 GMT

Interval Match works for matching the discrete numeric values (https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes/IntervalMatch.htm). Instead you can think this way? As a Qlik Consultant you have rights to ask Interviewer like "Even we have NetWorkDays - Why we need in Interval Match". But, To get an idea you can use this as well

Table:

Load WeekDay(DateField) as WeekDay

Resident Table;

Left Join(Table)

Load WeekDay Resident Table Where Not WildMatch(WeekDay,'Sat','Sun');