Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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..
Thank @dplr-rn but we don't have NPRINTING i think it is to expensive 😞
Thank you for the effort though
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
Tnx @agigliotti i intalled it but it won't let me export totals and the color formatting....
Right qlick and the export to Excel.