Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us at Qlik Connect 2026 in Orlando, April 13–15: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
jayashree28
Contributor II
Contributor II

Selection Syntax Fix for senseExcelTemplate

I am rendering Qlik charts in mashup using </Qlik embed/>. 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;

Reference link I used: https://qlik.dev/apis/rest/reports/ 

Qlik:
Tabular reporting template format: Excel

Output required: PDF

Mashup:
Input: senseExcelTemplate

Output: PDF

My payload to Qlik is

 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`
          }
        }
      }


Is there any problem in the syntax I am using for selections? Can anyone help me on this?

Labels (5)
0 Replies