Holidays in NetworkDays for Different Countries

[Anonymous]

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]

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

[Anonymous]

Yes it is Interview question

[Anil_Babu_Samineni]

Okay

[Anonymous]

Did you know the logic please share Anil

[Anil_Babu_Samineni]

Interval Match works for matching the discrete numeric values (https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes...). 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');