Qlik Community

Ask a Question

Qlik Design Blog

All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.

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

32 Comments
nagarjuna9563
Contributor
Contributor

Hi All,

when I am trying to create climber custom report by using extension in Qliksense, I have created some reports and added into the master items list. Even, climber custom report will not show reports in drop down list of visualizations tab in the climber custom report.

Please find the below screen shot for your reference.

Capture.PNG

Could you please help on this how to resolve it.

Thanks in Advance!!!

Regards,

Nagarjuna,

nidamanuri9563@gmail.com.

0 Likes
4,036 Views
kenji_khoo
Partner
Partner

Hi Everyone,

I'm using this extension, but my table can't show total. Please advice....

0 Likes
4,036 Views
michael_nordstr
Partner
Partner

Hi Kenji,

Look for the sum-symbol in the list of measures. Just click it and your sum will appear :-).

MeasureSums.png

(For Pivot tables in the subscription version the same feature is found under dimensions but since you are asking here I'm guessing you are on the free version.)

Hope this helps,

Michael

0 Likes
4,036 Views
kenji_khoo
Partner
Partner

Yes, i found that anyway after i commented here. LOL =D

0 Likes
4,036 Views
karla_gonzalez
Partner
Partner

Thanks

Jennell

0 Likes
3,044 Views
rambhargavk
Contributor
Contributor
hi i dowloaded the zip file from the git hub. it's not working when i try upload in to qlik sense june 2018 release.
0 Likes
2,720 Views
JordyWegman
Partner
Partner

Hi Rambharqavk,

We've just released our free trial of the Custom Report +, this means even more functionalities. You can download it via this link: https://lnkd.in/d4_hEj2

If you're having problems, just let me know.

Jordy

Climber

0 Likes
2,698 Views
kurtwert71
Contributor II
Contributor II

Hi! I am using the "VzLib Custom Report" which is what this climber extension has evolved into. But when I have a table with multiple columns, I don't know how to sort on them all. I can sort the first column, but not the others, so often the results look a little jumbled. Can I force it to sort on all the columns from left to right so it looks the way I want?

0 Likes
1,508 Views
JordyWegman
Partner
Partner

Hi Kurtwert,

Did you sort the columns in your original table? My suggestion would be to sort it there the way you want it, add then the table to the extension and they should appear in the order you have created them.

Jordy

Climber

0 Likes
1,503 Views
RadOresky
Luminary Alumni
Luminary Alumni

It's really good that the custom report, a.k.a. ad-hoc report, can be created natively without extensions, using the "show column if" option in straight and pivot table objects. Takes a bit more time to setup, but does the job pretty well.

I described my approach here.

-Radovan

0 Likes
227 Views