topic Re: Straight Table export in QlikView

Straight Table export

Mon, 10 Mar 2014 22:03:37 GMT

Hi Qlikvivewer,

I have a huge data in Straight Table which contains 75 rows and the user wants to export the data. I want to know if I can create a button and let the user export the data into their own desktop. The user will be accessing the data via AXJAX. Or if I can show partial of the data set, but when the user exports it, he/she will get the entire set.

Thanks in advance.

Jasmine

Re: Straight Table export

Carlos_Reyes — Mon, 10 Mar 2014 22:48:43 GMT

Why do you need a button? You can enable the "Export to Excel" icon in you Straight table properties.

Re: Straight Table export

Mon, 10 Mar 2014 22:54:51 GMT

Because the table has 74 rows and it won't into one screen and the user will have the scroll all the way to the end to export the data, so I want to create something I the user will see the entire set of data after he/she exports the table.

Re: Straight Table export

Carlos_Reyes — Mon, 10 Mar 2014 23:29:28 GMT

I don't really get what you're trying to explain. What I understand is that your straight table shows 74 rows... which is not a big deal, these are very few records... And, you don't need to scroll to see the "Export to Excel" icon. The object's caption is static.

If you can upload a sample app or at least an image it'll be easier to understand your problem.

Regards.

Re: Straight Table export

Fri, 05 Sep 2014 19:57:02 GMT

Hey Carlos,

I got somewhat similar issue. I have straight table with totals included and when I export to excel only the rows that have totals are shown but the rows- that have details that add up to these totals are not exported into excel. This could be some settings other than the check on "Export to Excel"? Please advise...

Thanks,

SaiLeela Maguluri

Re: Straight Table export

Fri, 05 Sep 2014 21:34:54 GMT

Can you attach the image of missing rows?

Re: Straight Table export

Fri, 05 Sep 2014 22:51:26 GMT

Suraj, I need to export to excel all the details as above from Straight table but when I export it only exports the totals as above(heighted/Blue Line) and not any details below nor the total monthly expenses etc. Wondering if its something with Qlikview straight table limitation (11.2)? Trying if there's any workaround. Thanks Much in advance for trying to help

Re: Straight Table export

Fri, 05 Sep 2014 23:15:27 GMT

I see some selection is made with the green light showing on the picture below the blue line. I think that selection is causing this issue.
Can you check the current Selections once you made the export. Does the table look same?

Also which browser are you trying to perform this action?

Thank you

Suraj

Re: Straight Table export

rwunderlich — Fri, 05 Sep 2014 23:46:53 GMT

That looks like two different tables to me. Is the details and total two separate objects?

Re: Straight Table export

Sat, 06 Sep 2014 01:35:04 GMT

Suraj,

I Browser is Internet Explorer. The table is good with selections, I don't think selections is an issue as the report is being used for quite a while now and the table looks the same after the export is made but it shows only the top row (totals) in excel.

Re: Straight Table export

Sat, 06 Sep 2014 01:36:27 GMT

Rob,

The details and Totals are all in one same object - straight table. Sorry, I didn't show a proper image

Re: Straight Table export

Sat, 06 Sep 2014 01:38:05 GMT

AQlso, Rob, I took the image that way to show that only the top portion (Totals) is shown in export

Re: Straight Table export

Sat, 06 Sep 2014 04:49:00 GMT

Maguluri,

Please can you try right clicking on the cells of the and click on send to excel and see?

Thanks

Suraj

Re: Straight Table export

Sat, 06 Sep 2014 10:21:39 GMT

Tried that Suraj. If I do that It only gives me the Details this time.
Thanks

Saileela

Re: Straight Table export

ajaykumar1 — Sat, 06 Sep 2014 10:27:00 GMT

Hi,

I always recommeneded to export excel use----Right click---Export---save.

This will work in all the cases.

Re: Straight Table export

Sat, 06 Sep 2014 10:33:26 GMT

Hi Ajay,

I only get the Details of the table, not the Totals if I do that....

Thanks,

SaiLeela

Re: Straight Table export

ajaykumar1 — Sat, 06 Sep 2014 10:39:49 GMT

Hi,

Can you post sample app with limited records or with some dummy data?

Re: Straight Table export

ashfaq_haseeb — Sun, 07 Sep 2014 06:41:08 GMT

Hi,

Can you post sample application.

http://community.qlik.com/docs/DOC-1290

Regards

ASHFAQ

Re: Straight Table export

Mon, 08 Sep 2014 04:59:33 GMT

Maguluri,

The developer seems to have the totals in a seperate straight box and details in another straight box..!! Might be tricking the users...!!

Re: Straight Table export

Mon, 08 Sep 2014 15:31:57 GMT

Hi Suraj,

You are right. This is a Massive Dashboard and the developer who worked on this Tab earlier has the Totals in Separate Straight Table. I’m trying to get this all into one. Thanks Much

Regards,

Saileela Maguluri