How to load all files excluding *Public Holiday* and *Week End* script in QlikSense

[Anil_Babu_Samineni]

Hello Friends,

This script initiate to exclude Saturday and Sunday from the files and Public Holidays.

What below script do is - It will fetch 2 date time stamp in X-Axis and Y-Axis in Sense. That means, If you look at below image it will show one dimension and 6 Measures. And that too it will indicate Vertical reference line and Area + Line charts together using extension(https://github.com/NielsLindberg/Qliksense.Extension.amWaterfall). Really interesting requirement. You can use same if you liked it.

There is X-Axis in that Vertical line also there. That means, Before Vertical line we are fetching data for Today's Date which is Working day and After vertical line LWD which is business day. So, I thought to share with you all to understand in future reference. I think, This is very neat and good.

Open it Notepad++ and use language as QlikView Plugin. For reference the image and Script attached