Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;