search

leematthewshome / Qlik-Sense-Transposed-Table-Extension

This visualisation extension for Qlik Sense allows for complex financial report style outputs, where each row is a unique calculation.
Apache License 2.0
8 stars 9 forks source link

Exporting Data Issue #4

Closed jmschrad closed 6 years ago

jmschrad commented 6 years ago

First, I love the table. I have an application I already am wanting to use it in. Thank you for your work.

Second, I have created a metric that displays a rolling 13 months. The data itself all exports correctly, but the field headings are off. The earliest month displays as one month greater than is displayed in Qlik. Jan 17 is Feb 17, Feb 17 is Mar 17...Jan 18 is Feb 18.

Let me know what you figure out. Again, I really like the extension!

I am using February 2018 Server - patch one.

leematthewshome commented 6 years ago

Are you talking about the export to Excel capability? Actually I didnt know that the export data function was enabled. The problem with that is that it exports the data in its original form....ie. not Transposed. I might have to disable that. Are you saying that the columns are not aligned with the data after exporting the data?

jmschrad commented 6 years ago

I did some more research. It looks like the issue was with my using monthend when I was creating my month-year string. I removed monthend and the export works correctly now.

leematthewshome commented 6 years ago

Thanks for the update. I was pretty sure it was working correctly, as that is the default export capability via the Qlik Engine and doesnt use any logic from the extension. That is why the data is not transposed. I might leave it in, as the user can transpose with Excel once they export anyway.

lgx0108 commented 5 years ago

Is it possible to enable 'Export to PDF' or 'Export as an image' and the layout to export as is?