exclude weekends and public holiday

[zuzaza]

Hi,

I have requirements. I already did Sum({$<Time = {">$(=('11:00'))<=$(=('12:00'))"},Time = {">$(=('14:00'))<=$(=('17:00'))"}>}[ Total kwh]) but I want to exclude saturday,sunday(weekends) and public holidays. The example data that I have is mostly like this: 

Date                Time          Total Kwh

1/6/2017         0:30            6000

2/6/2017         1:00             6000

.

.

.

.

.

But, I still get no result with my expression. 

Thanks in advance!

[bramkn]

create a flag in the script to determine what dates you want and do not want. and use that flag as a field in the set analysis. Also using Time=,Time= Will not work as far as I know. put all the expressions within one Time= in the set analysis.

[pradosh_thakur]

Use the below to determine which one is holiday and which one is not in script. Then use a binary flag to filter the out in set analysis.

https://community.qlik.com/t5/QlikView-Documents/Master-Calendar-with-movable-holidays/ta-p/1485255

https://community.qlik.com/t5/QlikView-Documents/Master-Calendar-with-Working-days-Holidays-Flag/ta-...

https://community.qlik.com/t5/QlikView-Documents/Calculating-Holidays-in-script/tac-p/1492779

[Channa]

only week ends you can do if you want to add public holidays add flag to ur database