Introducing Qlik Cloud Tabular Reporting

[Sonja_Bauernfeind]

We are excited to introduce tabular reporting from Qlik Cloud. Now customers can address common, centrally managed, tabular report distribution requirements from within a Qlik Sense Application! With tabular reporting, report developers can create custom and highly formatted XLS documents from Qlik data and Qlik visualizations; Governed Report Tasks can burst reports to any stakeholder, ensuring that the Qlik platform is the source for operational decisions, customer communications and more.

Some feature highlights:

• Report template creation, using data and visualizations from a Qlik Sense App, all with the familiarity of Microsoft Office 365 using Add-in technology
• Qlik Cloud governed report task control from within a Qlik Sense App
• In app distribution list management to support burst report distribution to any stakeholder (internal or external)
• Execution of Qlik NPrinting authored XLS report templates uploaded to Qlik Cloud
• Powered by the Qlik Reporting Service, reports are delivered from a scalable cloud service that solves complex enterprise reporting jobs

Want to get started with your first Tabular Report?

Access our Getting Started section in your Qlik Cloud app (available for users with Can Edit permissions). Open your app, (a) choose your activity, and select (b) Reporting.

From here, you can begin with our introductory videos and configuration instructions:

Want to know more about Qlik’s Tabular Reporting feature?

• See the Tabular Reporting introductory videos
• To get started see Tabular reporting in Qlik Cloud Analytics
• To access and discuss the Qlik NPrinting Technical Preview, go to Qlik's Technical Previews 
• The Qlik Excel add-in can be deployed and installed for compatible web and desktop versions of Microsoft Excel within Microsoft 365 see Deploying and installing the Qlik add-in for Microsoft Excel and speak with your Office 365 administrator if you wish to deploy the capability
• Generating tabular reports in Qlik Cloud Analytics is a value-add Qlik Reporting Service capability. Check with your service account owner about your Qlik Cloud subscription's included capacities. Please be aware that overage will be monitored and capped starting in 2024.
• Adopting customers should familiarize themselves with guardrails and limits see Qlik Reporting Service specifications and limitation

Thank you for choosing Qlik,
Qlik Support

[ester_pr]

Hi, great feature, thanks

I did all the steps and I get an error message when running the report, how do I find the reason?

 when editing I get

view

The email was checked and correct, I also tried a different email and still the same error

what should I do?

OH, there is an email setup on the server that works properly and sends emails

Ester

[Sonja_Bauernfeind]

Hello @ester_pr 

Please post about the issue in detail in the forums. Specifically the Reporting Service forums.

All the best,
Sonja 

[Andrew_Kruger]

@arychener   Please refer to the Qlik Reporting Service section at the link  Qlik Cloud subscription's which is found at https://www.qlik.com/us/legal/product-terms.  

[Andrew_Kruger]

@ester_pr  please post to the other forum as Sonja mentioned.  Have you checked the filter name included in the recipient file exactly matches the name of the filter in the Filters section?  

[ester_pr]

@Andrew_Kruger Thanks, yes I will post in  the other forum,
And the filters are the exact name

[Linda95]

Hi @Sonja_Bauernfeind, is there currently a way to plan report tasks based on active directory groups? Or do you plan implementing an integrated way to use the IdP Connection for that? Would be much easier than maintaining an excel file.

[David_Friend]

@Linda95 please post in the forum thanks! https://community.qlik.com/t5/Qlik-Reporting-Service/bd-p/reporting-service

[robert99]

@ester_pr 

I got the same error. But fixed it by turning off Section Access (hopefully this will be changed in a future update)

A bug? I found was if anything is in 'show column if' (even just a 1)  it doesn't show the column in the Excel table option. I had to make them blank.

Another change I made was to change the load script to 'automatically generated load script' as shown below. This allows a direct load of any User additions.

I also used the Brilliant new Container option a lot. That is putting all charts and tables into a Qlik Container then loading the one Container chart into Excel (it often still renders tables not too well but did work arounds like putting tables on the bottom of this Container etc)

Overall another excellent addition to Qlik. I hope the above issues are fixed and also to allow Pivot tables to be added.

Changed script 

Replace LOAD
"Name" AS [DL_DISTRIBUTION_RECIPIENT_NAME],
"Email" AS [DL_DISTRIBUTION_EMAIL],
SubField([Filters],',') AS [DL_DISTRIBUTION_FILTERS],
SubField([Groups],',') AS [DL_DISTRIBUTION_GROUP_NAMES]
//FROM "lib://0. Management:DataFiles/reporting_source_edca58c3-9dba-4397-9476-f68c647fdc37.xlsx"
//(ooxml, embedded labels, table is DL_DISTRIBUTION_SVC_USERS_QCS)
;
//level 1
LOAD
Name,
Email,
"Filters",
"Groups"
FROM [lib://connect:OneDrive_qlikservice/ExcelUploadedQlik/ReportingExcel.xlsx]
(ooxml, embedded labels, table is DL_DISTRIBUTION_SVC_USERS_QCS);

TempGroups:

REPLACE LOAD

    *

    FROM [lib://connect:OneDrive_qlikservice/ExcelUploadedQlik/ReportingExcel.xlsx]

(ooxml, embedded labels, table is DL_DISTRIBUTION_SVC_GROUPS_QCS);