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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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