Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
Sonja_Bauernfeind
Digital Support
Digital Support

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.

access reporting.png

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

getting started with tabular reporting.png

 

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

 

Thank you for choosing Qlik,
Qlik Support

 

28 Comments
ester_pr
Partner - Creator
Partner - Creator

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?

ester_pr_0-1703064837881.png

 when editing I get

ester_pr_2-1703064923251.png

view

ester_pr_3-1703064959347.png

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

991 Views
Sonja_Bauernfeind
Digital Support
Digital Support

Hello @ester_pr 

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

All the best,
Sonja 

935 Views
Andrew_Kruger
Employee
Employee

@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.  

 

911 Views
Andrew_Kruger
Employee
Employee

@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?  

839 Views
ester_pr
Partner - Creator
Partner - Creator

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

781 Views
Linda95
Contributor
Contributor

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.

675 Views
David_Friend
Support
Support
640 Views
robert99
Specialist III
Specialist III

@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);
536 Views