Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gorterzelf7
Partner - Creator
Partner - Creator

When exporting from a QlikSense Straight table to Excel is there a way to keep totals and color

I really don't know how to do this. I tried the extensions:

1: https://github.com/CodeAtRoost/Qlik-Dot-Net-SDK-Excel-download-with-color-code (failed to import extensions because path is to long)

2: https://github.com/iviasensio/SmartExport (is working with small tables but gives errors when exporting and when table is to long with hypercube)

3: https://github.com/stefanwalther/sense-export is not flexible, i wan't the users to built there table....

I really hope somebody knows a good solution for this, because all my customers ask for this.

With kind regards Martijn

Labels (3)
13 Replies
dplr-rn
Partner - Master III
Partner - Master III

I can only think of NPrinting reports on demand
OmarBenSalem

Don't know for the color, but I have one solution

Create a new column:

=aggr(if(len(below(OneOfYourDimensionsInTheTable))>0,'', Sum(TOTAL YourMeasure)),OneOfYourDimensionsInTheTable)

 

Result per analogy:

Capture.PNG

Capture.PNG

Hope this helps..

agigliotti
Partner - Champion
Partner - Champion

I suggest you to take a look at https://www.vizlib.com/table/
it's a trusted extension that keep formatting in excel export.

I hope it can help.
gorterzelf7
Partner - Creator
Partner - Creator
Author

Thank @dplr-rn but we don't have NPRINTING i think it is to expensive 😞 

Thank you for the effort though

gorterzelf7
Partner - Creator
Partner - Creator
Author

Thank @OmarBenSalem but i have to many colomns with metrics sometimes arrount 100, so that will take to much space 😞 

Thank you for the effort though

gorterzelf7
Partner - Creator
Partner - Creator
Author

Tnx @agigliotti i intalled it but it won't let me export totals and the color formatting....

agigliotti
Partner - Champion
Partner - Champion

what menu option did you select to export ?
gorterzelf7
Partner - Creator
Partner - Creator
Author

Right qlick and the export to Excel.

agigliotti
Partner - Champion
Partner - Champion

I know with VizLib Pivot Table there is "Export Formatted Data to Excel" option on right click.