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

[gorterzelf7]

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

[dplr-rn]

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:

Hope this helps..

[agigliotti]

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]

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

Thank you for the effort though

[gorterzelf7]

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]

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

[agigliotti]

what menu option did you select to export ?

[gorterzelf7]

Right qlick and the export to Excel.

[agigliotti]

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