topic Exclude saturday, Sunday and public holidays in Reporting Service & Alerting

topic Exclude saturday, Sunday and public holidays in Reporting Service & Alerting https://community.qlik.com/t5/Reporting-Service-Alerting/Exclude-saturday-Sunday-and-public-holidays/m-p/2484528#M1186 <ARTICLE class="w-full text-token-text-primary focus-visible:outline-2 focus-visible:outline-offset-[-4px]" dir="auto" data-testid="conversation-turn-2" data-scroll-anchor="false"> <DIV class="text-base py-[18px] px-3 md:px-4 m-auto w-full md:px-5 lg:px-4 xl:px-5"> <DIV class="mx-auto flex flex-1 gap-4 text-base md:gap-5 lg:gap-6 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem]"> <DIV class="group/conversation-turn relative flex w-full min-w-0 flex-col"> <DIV class="flex-col gap-1 md:gap-3"> <DIV class="flex max-w-full flex-col flex-grow"> <DIV class="min-h-8 text-message flex w-full flex-col items-end gap-2 whitespace-normal break-words [.text-message+&]:mt-5" dir="auto" data-message-author-role="user" data-message-id="aaa28fc1-b952-4c41-acf5-0c9b0971e3ff"> <DIV class="flex w-full flex-col gap-1 empty:hidden items-end rtl:items-start"> <DIV class="relative max-w-[70%] rounded-3xl px-5 py-2.5 bg-[#f4f4f4] dark:bg-token-main-surface-secondary"> <DIV class="whitespace-pre-wrap">Last one year sum (Sales) there exclude saturday, Sunday and public holidays formula in qlik sense with Example</DIV> <DIV class="absolute bottom-0 right-full top-0 -mr-3.5 hidden pr-5 pt-1 [.group\/conversation-turn:hover_&]:block"> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </ARTICLE> <ARTICLE class="w-full text-token-text-primary focus-visible:outline-2 focus-visible:outline-offset-[-4px]" dir="auto" data-testid="conversation-turn-3" data-scroll-anchor="false"> <H6 class="sr-only"> </H6> </ARTICLE> Tue, 01 Oct 2024 05:28:50 GMT kumaru 2024-10-01T05:28:50Z Exclude saturday, Sunday and public holidays https://community.qlik.com/t5/Reporting-Service-Alerting/Exclude-saturday-Sunday-and-public-holidays/m-p/2484528#M1186 <ARTICLE class="w-full text-token-text-primary focus-visible:outline-2 focus-visible:outline-offset-[-4px]" dir="auto" data-testid="conversation-turn-2" data-scroll-anchor="false"> <DIV class="text-base py-[18px] px-3 md:px-4 m-auto w-full md:px-5 lg:px-4 xl:px-5"> <DIV class="mx-auto flex flex-1 gap-4 text-base md:gap-5 lg:gap-6 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem]"> <DIV class="group/conversation-turn relative flex w-full min-w-0 flex-col"> <DIV class="flex-col gap-1 md:gap-3"> <DIV class="flex max-w-full flex-col flex-grow"> <DIV class="min-h-8 text-message flex w-full flex-col items-end gap-2 whitespace-normal break-words [.text-message+&]:mt-5" dir="auto" data-message-author-role="user" data-message-id="aaa28fc1-b952-4c41-acf5-0c9b0971e3ff"> <DIV class="flex w-full flex-col gap-1 empty:hidden items-end rtl:items-start"> <DIV class="relative max-w-[70%] rounded-3xl px-5 py-2.5 bg-[#f4f4f4] dark:bg-token-main-surface-secondary"> <DIV class="whitespace-pre-wrap">Last one year sum (Sales) there exclude saturday, Sunday and public holidays formula in qlik sense with Example</DIV> <DIV class="absolute bottom-0 right-full top-0 -mr-3.5 hidden pr-5 pt-1 [.group\/conversation-turn:hover_&]:block"> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </ARTICLE> <ARTICLE class="w-full text-token-text-primary focus-visible:outline-2 focus-visible:outline-offset-[-4px]" dir="auto" data-testid="conversation-turn-3" data-scroll-anchor="false"> <H6 class="sr-only"> </H6> </ARTICLE> Tue, 01 Oct 2024 05:28:50 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/Exclude-saturday-Sunday-and-public-holidays/m-p/2484528#M1186 kumaru 2024-10-01T05:28:50Z Re: Exclude saturday, Sunday and public holidays https://community.qlik.com/t5/Reporting-Service-Alerting/Exclude-saturday-Sunday-and-public-holidays/m-p/2484580#M1187 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/314086">@kumaru</a>  could you share more details. refer to the below post</P> <P><A href="https://community.qlik.com/t5/Water-Cooler/How-to-Ask-Great-Questions-in-the-Qlik-Community/td-p/2463979" target="_blank">https://community.qlik.com/t5/Water-Cooler/How-to-Ask-Great-Questions-in-the-Qlik-Community/td-p/2463979</A></P> <P> </P> Tue, 01 Oct 2024 09:05:50 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/Exclude-saturday-Sunday-and-public-holidays/m-p/2484580#M1187 Kushal_Chawda 2024-10-01T09:05:50Z