Exclude Weekend from calculation

[Anonymous]

I am new to the Qlik Sense development, and I loaded the data from Oracle database and presented the same in the required format via Bar chart, Later I realised the Data I loaded the data included the weekend and public holiday as well. I would like to understand if we have and conditional script to exclude the weekend data from the calculation. Basically, I just need to present on weekdays data and not the others.

Thanks in Advance.

Regards

Vishal 

[Ivan_Bozov]

Here you go: https://help.qlik.com/en-US/sense-cloud/Subsystems/CloudHub/Content/Sense_Hub/Scripting/DateAndTimeF...

[Anil_Babu_Samineni]

I can think This way, May be?

Connection String Here..

Table:

Load * Where Not WildMatch(WeekDay(Date(Date#(DateField,'Your Format Here'))),'Sat', 'Sun');

SQL Select * From Table;