<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Conditional Report Task Execution in Reporting Service &amp; Alerting</title>
    <link>https://community.qlik.com/t5/Reporting-Service-Alerting/Conditional-Report-Task-Execution/m-p/2521969#M2451</link>
    <description>&lt;P&gt;At Qlik Connect I had a few customer / partner discussions about conditional report task execution.&amp;nbsp; There are a few flavors of interest here:&lt;/P&gt;
&lt;OL&gt;
&lt;LI&gt;Only execute the task (in entirety) if a data condition exists&lt;/LI&gt;
&lt;LI&gt;Conditional distribution to a specific recipient within a task.&amp;nbsp; An ideation captures this interest here &lt;A href="https://ideation.qlik.com/app/#/case/359666?cpid=85074b5c-74da-49ab-9934-67071023304d" target="_blank"&gt;https://ideation.qlik.com/app/#/case/359666?cpid=85074b5c-74da-49ab-9934-67071023304d&lt;/A&gt;&lt;/LI&gt;
&lt;/OL&gt;
&lt;P&gt;These are both great capability interests which will get prioritized against the various feature requests we receive (there are many :-)).&amp;nbsp; Keep the great feedback coming on &lt;A href="https://community.qlik.com/t5/Ideation/ct-p/qlik-product-insight" target="_self"&gt;Qlik Ideation&lt;/A&gt;!&lt;/P&gt;
&lt;H3&gt;What are your options today?&lt;/H3&gt;
&lt;P&gt;&lt;STRONG&gt;Only execute the task (in entirety) if a data condition exists &lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;Today you can setup a &lt;A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/cloud-in-app-reports-tasks.htm" target="_self"&gt;report task&lt;/A&gt;&amp;nbsp;and configure it to execute based on a schedule or when data changes.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;However if the interest is for the basic scenario of only execute a task if some specific data state occurs you could consider a simple automation to verify the condition state and trigger the report task via &lt;A href="https://qlik.dev/apis/rest/sharing-tasks/#post-v1-sharing-tasks-actions-execute" target="_blank"&gt;Sharing Task API&lt;/A&gt;.&amp;nbsp; The benefits here is that you maintain the report task integrity with the integrated distribution list, history execution, filter control etc.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;The steps to take are:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Configure your report task in-app inclusive of, distribution list, filters, and schedule, etc.&lt;/LI&gt;
&lt;LI&gt;Set the Task to a &lt;EM&gt;Disable&lt;/EM&gt; state&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Andrew_Kruger_0-1750683416503.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/181529iDEF4D14C6CED321C/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Andrew_Kruger_0-1750683416503.png" alt="Andrew_Kruger_0-1750683416503.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Create an Automation to execute a sharing task using the Raw API block&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Andrew_Kruger_1-1750683416506.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/181530i26AE8DB9D6305AEB/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Andrew_Kruger_1-1750683416506.png" alt="Andrew_Kruger_1-1750683416506.png" /&gt;&lt;/span&gt;&lt;/LI&gt;
&lt;LI&gt;Within the automation use the various Qlik Connector blocks to check the data conditions you might use to determine whether the report task can execute.&lt;/LI&gt;
&lt;/UL&gt;
&lt;H4&gt;Tracking down the Report Task ID&lt;/H4&gt;
&lt;UL&gt;
&lt;LI&gt;You will need the ID for the report task to configure the API call – this is easily obtained via the &lt;A href="https://qlik.dev/apis/rest/sharing-tasks/#get-v1-sharing-tasks" target="_blank"&gt;Sharing &lt;/A&gt;&lt;A href="https://qlik.dev/apis/rest/sharing-tasks/#get-v1-sharing-tasks" target="_self"&gt;Task – List all Sharing Tasks&lt;/A&gt; and a browser when logged into your tenant.&amp;nbsp; Be sure to specify the filter &lt;EM&gt;type=template-sharing (and optionally the appId if you have a lot of tasks)&lt;/EM&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Andrew_Kruger_2-1750683416509.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/181531iAD4BF99132E55049/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Andrew_Kruger_2-1750683416509.png" alt="Andrew_Kruger_2-1750683416509.png" /&gt;&lt;/span&gt;&lt;/LI&gt;
&lt;LI&gt;Search for the Task Name (assuming you have made it unique) and grab the “ID” value at the root of definition for the task (be sure to grab the correct “ID” - there are a few in the payload).&amp;nbsp;&lt;/LI&gt;
&lt;LI&gt;Of course - always test before placing this strategy in operation&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;Conditional distribution to a specific recipient within a task&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;This is a much more complex requirement as it is a recipient level decision on whether to distribute the report.&amp;nbsp; This could be at the recipient level or even at the cycle level.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Today the task will send a file to every recipient, even if the file is empty.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Today there is no way maintain the report task structure and achieve this outcome – again we have an ideation linked above for which more feedback is welcome.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;For the adventurous – an option would be to use Qlik Automate to build your own report task – which would entail&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Source recipient list and execute via looping&lt;/LI&gt;
&lt;LI&gt;building a temp bookmark for each recipient&lt;/LI&gt;
&lt;LI&gt;requesting the corresponding report using the &lt;A href="https://community.qlik.com/t5/Official-Support-Articles/New-reporting-blocks-for-Qlik-Automate-Get-PixelPerfect-Report/ta-p/2518483" target="_blank"&gt;Tabular and PixelPerfect blocks in Qlik Automate&lt;/A&gt;&lt;/LI&gt;
&lt;LI&gt;managing the channel of distribution&lt;/LI&gt;
&lt;LI&gt;writing your own audit log&lt;/LI&gt;
&lt;LI&gt;testing!&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Hopefully this post offers some ideas to consider while conditional report task execution makes its way through ongoing roadmap evaluation/prioritization.&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Mon, 23 Jun 2025 13:16:39 GMT</pubDate>
    <dc:creator>Andrew_Kruger</dc:creator>
    <dc:date>2025-06-23T13:16:39Z</dc:date>
    <item>
      <title>Conditional Report Task Execution</title>
      <link>https://community.qlik.com/t5/Reporting-Service-Alerting/Conditional-Report-Task-Execution/m-p/2521969#M2451</link>
      <description>&lt;P&gt;At Qlik Connect I had a few customer / partner discussions about conditional report task execution.&amp;nbsp; There are a few flavors of interest here:&lt;/P&gt;
&lt;OL&gt;
&lt;LI&gt;Only execute the task (in entirety) if a data condition exists&lt;/LI&gt;
&lt;LI&gt;Conditional distribution to a specific recipient within a task.&amp;nbsp; An ideation captures this interest here &lt;A href="https://ideation.qlik.com/app/#/case/359666?cpid=85074b5c-74da-49ab-9934-67071023304d" target="_blank"&gt;https://ideation.qlik.com/app/#/case/359666?cpid=85074b5c-74da-49ab-9934-67071023304d&lt;/A&gt;&lt;/LI&gt;
&lt;/OL&gt;
&lt;P&gt;These are both great capability interests which will get prioritized against the various feature requests we receive (there are many :-)).&amp;nbsp; Keep the great feedback coming on &lt;A href="https://community.qlik.com/t5/Ideation/ct-p/qlik-product-insight" target="_self"&gt;Qlik Ideation&lt;/A&gt;!&lt;/P&gt;
&lt;H3&gt;What are your options today?&lt;/H3&gt;
&lt;P&gt;&lt;STRONG&gt;Only execute the task (in entirety) if a data condition exists &lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;Today you can setup a &lt;A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/cloud-in-app-reports-tasks.htm" target="_self"&gt;report task&lt;/A&gt;&amp;nbsp;and configure it to execute based on a schedule or when data changes.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;However if the interest is for the basic scenario of only execute a task if some specific data state occurs you could consider a simple automation to verify the condition state and trigger the report task via &lt;A href="https://qlik.dev/apis/rest/sharing-tasks/#post-v1-sharing-tasks-actions-execute" target="_blank"&gt;Sharing Task API&lt;/A&gt;.&amp;nbsp; The benefits here is that you maintain the report task integrity with the integrated distribution list, history execution, filter control etc.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;The steps to take are:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Configure your report task in-app inclusive of, distribution list, filters, and schedule, etc.&lt;/LI&gt;
&lt;LI&gt;Set the Task to a &lt;EM&gt;Disable&lt;/EM&gt; state&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Andrew_Kruger_0-1750683416503.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/181529iDEF4D14C6CED321C/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Andrew_Kruger_0-1750683416503.png" alt="Andrew_Kruger_0-1750683416503.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Create an Automation to execute a sharing task using the Raw API block&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Andrew_Kruger_1-1750683416506.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/181530i26AE8DB9D6305AEB/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Andrew_Kruger_1-1750683416506.png" alt="Andrew_Kruger_1-1750683416506.png" /&gt;&lt;/span&gt;&lt;/LI&gt;
&lt;LI&gt;Within the automation use the various Qlik Connector blocks to check the data conditions you might use to determine whether the report task can execute.&lt;/LI&gt;
&lt;/UL&gt;
&lt;H4&gt;Tracking down the Report Task ID&lt;/H4&gt;
&lt;UL&gt;
&lt;LI&gt;You will need the ID for the report task to configure the API call – this is easily obtained via the &lt;A href="https://qlik.dev/apis/rest/sharing-tasks/#get-v1-sharing-tasks" target="_blank"&gt;Sharing &lt;/A&gt;&lt;A href="https://qlik.dev/apis/rest/sharing-tasks/#get-v1-sharing-tasks" target="_self"&gt;Task – List all Sharing Tasks&lt;/A&gt; and a browser when logged into your tenant.&amp;nbsp; Be sure to specify the filter &lt;EM&gt;type=template-sharing (and optionally the appId if you have a lot of tasks)&lt;/EM&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Andrew_Kruger_2-1750683416509.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/181531iAD4BF99132E55049/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Andrew_Kruger_2-1750683416509.png" alt="Andrew_Kruger_2-1750683416509.png" /&gt;&lt;/span&gt;&lt;/LI&gt;
&lt;LI&gt;Search for the Task Name (assuming you have made it unique) and grab the “ID” value at the root of definition for the task (be sure to grab the correct “ID” - there are a few in the payload).&amp;nbsp;&lt;/LI&gt;
&lt;LI&gt;Of course - always test before placing this strategy in operation&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;Conditional distribution to a specific recipient within a task&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;This is a much more complex requirement as it is a recipient level decision on whether to distribute the report.&amp;nbsp; This could be at the recipient level or even at the cycle level.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Today the task will send a file to every recipient, even if the file is empty.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Today there is no way maintain the report task structure and achieve this outcome – again we have an ideation linked above for which more feedback is welcome.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;For the adventurous – an option would be to use Qlik Automate to build your own report task – which would entail&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Source recipient list and execute via looping&lt;/LI&gt;
&lt;LI&gt;building a temp bookmark for each recipient&lt;/LI&gt;
&lt;LI&gt;requesting the corresponding report using the &lt;A href="https://community.qlik.com/t5/Official-Support-Articles/New-reporting-blocks-for-Qlik-Automate-Get-PixelPerfect-Report/ta-p/2518483" target="_blank"&gt;Tabular and PixelPerfect blocks in Qlik Automate&lt;/A&gt;&lt;/LI&gt;
&lt;LI&gt;managing the channel of distribution&lt;/LI&gt;
&lt;LI&gt;writing your own audit log&lt;/LI&gt;
&lt;LI&gt;testing!&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Hopefully this post offers some ideas to consider while conditional report task execution makes its way through ongoing roadmap evaluation/prioritization.&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 23 Jun 2025 13:16:39 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Reporting-Service-Alerting/Conditional-Report-Task-Execution/m-p/2521969#M2451</guid>
      <dc:creator>Andrew_Kruger</dc:creator>
      <dc:date>2025-06-23T13:16:39Z</dc:date>
    </item>
    <item>
      <title>Re: Conditional Report Task Execution</title>
      <link>https://community.qlik.com/t5/Reporting-Service-Alerting/Conditional-Report-Task-Execution/m-p/2522564#M2478</link>
      <description>&lt;P&gt;Nice recap, thank you!&lt;/P&gt;</description>
      <pubDate>Fri, 27 Jun 2025 09:25:54 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Reporting-Service-Alerting/Conditional-Report-Task-Execution/m-p/2522564#M2478</guid>
      <dc:creator>F_B</dc:creator>
      <dc:date>2025-06-27T09:25:54Z</dc:date>
    </item>
    <item>
      <title>Re: Conditional Report Task Execution</title>
      <link>https://community.qlik.com/t5/Reporting-Service-Alerting/Conditional-Report-Task-Execution/m-p/2524338#M2489</link>
      <description>&lt;P&gt;Don't know if it's better or worse (or easier), but all I did was add a variable in the app to count the rows of a table that needs to be populated, then get the value and used it in a condition:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mikecrengland_1-1752614753339.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/182119iD061A874DC096E29/image-size/medium?v=v2&amp;amp;px=400" role="button" title="mikecrengland_1-1752614753339.png" alt="mikecrengland_1-1752614753339.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mikecrengland_3-1752614801741.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/182121i6AC345771625C5FF/image-size/medium?v=v2&amp;amp;px=400" role="button" title="mikecrengland_3-1752614801741.png" alt="mikecrengland_3-1752614801741.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mikecrengland_0-1752614684526.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/182118iDE47B05CE3B7D04F/image-size/medium?v=v2&amp;amp;px=400" role="button" title="mikecrengland_0-1752614684526.png" alt="mikecrengland_0-1752614684526.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 15 Jul 2025 21:28:17 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Reporting-Service-Alerting/Conditional-Report-Task-Execution/m-p/2524338#M2489</guid>
      <dc:creator>mikecrengland</dc:creator>
      <dc:date>2025-07-15T21:28:17Z</dc:date>
    </item>
    <item>
      <title>Re: Conditional Report Task Execution</title>
      <link>https://community.qlik.com/t5/Reporting-Service-Alerting/Conditional-Report-Task-Execution/m-p/2538755#M2668</link>
      <description>&lt;P&gt;Why not just give us conditional menu in report view next to filters (just like npringing had) and let us set expression to check if example =max(Date)=today(1))?&amp;nbsp; Let us set that as global condition in app or something user can pick from report task schedule.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 10 Dec 2025 06:21:58 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Reporting-Service-Alerting/Conditional-Report-Task-Execution/m-p/2538755#M2668</guid>
      <dc:creator>MikkoL</dc:creator>
      <dc:date>2025-12-10T06:21:58Z</dc:date>
    </item>
  </channel>
</rss>

