Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
Jennell_McIntire
Employee
Employee

A couple of years ago I wrote a blog on customizing straight tables in QlikView explaining how you can add an ad-hoc report to your QlikView app.  So, I thought I would share how you can now create a custom report in Qlik Sense using the Climber Custom Report extension.  The Climber Custom Report is an extension that can be added to your Qlik Sense app to give users the ability to create their own ad-hoc reports.  In this blog, I will show you how easy it is to add a custom report to your app using Qlik Sense Desktop.

  1. The first step is to download the Climber Custom Report extension from Qlik Branch, unzip it and put it in your Extensions folder (C:\Users\xxx\Documents\Qlik\Sense\Extensions).
  2. In your Qlik Sense app, create a table with all the possible dimensions and measures a user may want to see in a report and then add the table to master items.  The table may look something like this: table.png
  3. Add the Climber Custom Report extension to a sheet in your app and then you are ready to create a report.
  4. In the Visualizations drop down, select the report you just created.  All tables that are in your visualization master items will be listed in the drop down.  Once the table is selected, the dimension and measure lists will be populated with the dimensions and measures that are used in the table as seen below.dimensions and measures.png
  5. Select the dimensions and measures you would like to add to your report by clicking on them.  Your report will look something like the image below after you make some selections.  The dimensions are blue and the measures are orange.selections.png
  6. From the custom report bar above the chart, you can remove a dimension or measure by clicking the x and you can change the order of the columns by dragging and dropping the dimensions and measures into the order you would like them to appear in the report.

And that is it - it is that simple to add a custom report to your Qlik Sense app.  With Qlik Sense self-service, a user can create a report by dragging and dropping dimensions and measures into a table but what I like about the Climber Custom Report extension is it makes everything available to the user with a clean, professional and organized look.  Download it now and test it out for yourself.  See the extension in action in the Situational Awareness demo.  Note - the Climber Custom Report extension works in Qlik Sense 3.0 and higher and, like all extensions, are not supported by Qlik.

Thanks,

Jennell

39 Comments
veronicahernand
Partner - Contributor III
Partner - Contributor III

Hi!!

Do you know if there is any way to export it to excel with the totals of the columns¿?

I haven't fount the option... 😞

Thank you very much!

0 Likes
878 Views
rarpecalibrate
Contributor III
Contributor III

Hi @veronicahernand,

Unfortunately this is not an option on the free version. I am quite certain that vizlib's custom report (formally know as the Climber Table) has this functionality 

Ryan Arpe 

0 Likes
866 Views
VladKomarov
Partner - Contributor III
Partner - Contributor III

Hi All,

Great extension, I am using it very often. 

But did anybody try to import it and use it in SaaS?

I would appreciate the feedback.

 

Vlad

747 Views
JordyWegman
Partner - Master
Partner - Master

@VladKomarov  yes that is possible.

We use it for multiple customers now in SaaS!

Jordy

Climber

725 Views
VladKomarov
Partner - Contributor III
Partner - Contributor III

Thank you, @JordyWegman !

I've set it on my client's tenant and it seems to be working fine.

The only issue I've found is that it's not handling very well the case when I need to show/hide dimensions and measures in the master table I've linked with this extension. The items' selections in the extension itself work fine, but if I put 0 in the "Show Column If" section of item's property, the corresponding item is still visible in the extension. It requires the page refresh to work. And it applies to both show or hide cases.

VladKomarov_0-1645545549795.png

Other than that, it works fine. 

Thank you for your comment.

Regards,

Vlad

 

699 Views
MendyS
Partner - Creator III
Partner - Creator III

Hi all,

after we upgrade to May 22 patch 5 we notice that the extension is not working, someone is aware of that?

638 Views
mahrholt
Partner - Contributor III
Partner - Contributor III

@MendyS which version of the extension are you using?  

606 Views
MendyS
Partner - Creator III
Partner - Creator III

@mahrholt 


Version - 1.1.0  

Attach a screenshot

MendyS_0-1662549738930.png

 

590 Views
mahrholt
Partner - Contributor III
Partner - Contributor III

@MendyS  thanks.  I see that this is a separate extension from the old Climber Custom Report originally referenced so I don't have too much to add here.  But I can see you have already logged an issue so hopefully they can get it fixed. 

560 Views