Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

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)
12 Replies
Partner
Partner

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

I can only think of NPrinting reports on demand
Partner
Partner

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

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

Partner
Partner

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

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

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

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

Thank you for the effort though

Partner
Partner

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

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

Partner
Partner

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

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

Partner
Partner

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

what menu option did you select to export ?
Partner
Partner

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

Right qlick and the export to Excel.

Partner
Partner

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

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