<?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 Selection Syntax Fix for senseExcelTemplate in Reporting Service &amp; Alerting</title>
    <link>https://community.qlik.com/t5/Reporting-Service-Alerting/Selection-Syntax-Fix-for-senseExcelTemplate/m-p/2546540#M2760</link>
    <description>&lt;P&gt;I am rendering Qlik charts in mashup using &amp;lt;/Qlik embed/&amp;gt;. I am trying to implement an on-demand report PDF download (done using tabular reporting in Qlik) functionality in mashup. I tried following the instructions in the below link, the report is downloading but any selections is not reflecting in the downloaded report;&lt;/P&gt;&lt;P&gt;Reference link I used: &lt;A href="https://qlik.dev/apis/rest/reports/" target="_blank" rel="noopener"&gt;https://qlik.dev/apis/rest/reports/&lt;/A&gt;&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Qlik:&lt;BR /&gt;&lt;/STRONG&gt;Tabular reporting template format: Excel&lt;/P&gt;&lt;P&gt;Output required: PDF&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Mashup&lt;/STRONG&gt;:&lt;BR /&gt;Input:&amp;nbsp;senseExcelTemplate&lt;/P&gt;&lt;P&gt;Output: PDF&lt;/P&gt;&lt;P&gt;My payload to Qlik is&lt;/P&gt;&lt;LI-CODE lang="markup"&gt; const reportPayload =       {
        type: "sense-excel-template-1.0",
        meta: {
          exportDeadline: "P0Y0M0DT1H0M0S",
          tags: ["sense-ondemand.download"] },
        output: {
          outputId: "pdf_file",
          pdfOutput: {},
          type: "pdf"
        },
        senseExcelTemplate:
        {
          jsOpts: {
            language: "en",
            theme: "Theme1"
          },
          selectionChain: [
            {
              selectionType: "selectionFilter",
              selectionFilter:
              {
                fieldName: "List_",
                values: [
                  {
                    text: "Latest",
                    isNumeric: false
                  }
                ],
                defaultIsNumeric: false
              }
 
            }
          ],
 
          templateLocation: {
            format: "url",
            path:  `https://tenet.region.qlikcloud.com/api/v1/report-templates/templateId`
          }
        }
      }&lt;/LI-CODE&gt;&lt;P&gt;&lt;BR /&gt;Is there any problem in the syntax I am using for selections? Can anyone help me on this?&lt;/P&gt;</description>
    <pubDate>Thu, 09 Apr 2026 15:43:13 GMT</pubDate>
    <dc:creator>jayashree28</dc:creator>
    <dc:date>2026-04-09T15:43:13Z</dc:date>
    <item>
      <title>Selection Syntax Fix for senseExcelTemplate</title>
      <link>https://community.qlik.com/t5/Reporting-Service-Alerting/Selection-Syntax-Fix-for-senseExcelTemplate/m-p/2546540#M2760</link>
      <description>&lt;P&gt;I am rendering Qlik charts in mashup using &amp;lt;/Qlik embed/&amp;gt;. I am trying to implement an on-demand report PDF download (done using tabular reporting in Qlik) functionality in mashup. I tried following the instructions in the below link, the report is downloading but any selections is not reflecting in the downloaded report;&lt;/P&gt;&lt;P&gt;Reference link I used: &lt;A href="https://qlik.dev/apis/rest/reports/" target="_blank" rel="noopener"&gt;https://qlik.dev/apis/rest/reports/&lt;/A&gt;&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Qlik:&lt;BR /&gt;&lt;/STRONG&gt;Tabular reporting template format: Excel&lt;/P&gt;&lt;P&gt;Output required: PDF&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Mashup&lt;/STRONG&gt;:&lt;BR /&gt;Input:&amp;nbsp;senseExcelTemplate&lt;/P&gt;&lt;P&gt;Output: PDF&lt;/P&gt;&lt;P&gt;My payload to Qlik is&lt;/P&gt;&lt;LI-CODE lang="markup"&gt; const reportPayload =       {
        type: "sense-excel-template-1.0",
        meta: {
          exportDeadline: "P0Y0M0DT1H0M0S",
          tags: ["sense-ondemand.download"] },
        output: {
          outputId: "pdf_file",
          pdfOutput: {},
          type: "pdf"
        },
        senseExcelTemplate:
        {
          jsOpts: {
            language: "en",
            theme: "Theme1"
          },
          selectionChain: [
            {
              selectionType: "selectionFilter",
              selectionFilter:
              {
                fieldName: "List_",
                values: [
                  {
                    text: "Latest",
                    isNumeric: false
                  }
                ],
                defaultIsNumeric: false
              }
 
            }
          ],
 
          templateLocation: {
            format: "url",
            path:  `https://tenet.region.qlikcloud.com/api/v1/report-templates/templateId`
          }
        }
      }&lt;/LI-CODE&gt;&lt;P&gt;&lt;BR /&gt;Is there any problem in the syntax I am using for selections? Can anyone help me on this?&lt;/P&gt;</description>
      <pubDate>Thu, 09 Apr 2026 15:43:13 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Reporting-Service-Alerting/Selection-Syntax-Fix-for-senseExcelTemplate/m-p/2546540#M2760</guid>
      <dc:creator>jayashree28</dc:creator>
      <dc:date>2026-04-09T15:43:13Z</dc:date>
    </item>
  </channel>
</rss>

