Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Qv.Document.GetObject never completes for pivot charts when the Pagesize.x is greater than 40

Hi,

I am trying to export some pivot table charts to Excel using the Javascript API. By default QV just gets 40 rows and 40 columns of data. When I set the columns to more than 40, the GetObject("objectId",callback) never completes. It works fine when setting the rows to more than 40. 

Looking a the dev panel in Chrome, it just gets into a loop that continuously requests the data (and actually gets all the columns) but it never completes and returns the data back to the .Data object. 

I tried paging, but that only allows me to page through rows, not columns. 

Is there a way around this? I am trying to avoid VB Macro because Qlik doesn't support them anymore.

 

I have attached a demo. By default, the selections filters the pivot to less than 40 columns so the export button works. (you get an alert after it finishes) If you clear filters to get all the columns, it just hangs and never completes. 

Thanks

Labels (2)
2 Replies
Highlighted
Digital Support
Digital Support

I would imagine you are running into the issue described in the following Article:

https://support.qlik.com/articles/000040134 

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Highlighted
Creator
Creator

No, the article is referring to the horizontal view of a straight table chart rather than a pivot chart. I can see all the columns being displayed, just the API causes Qlikview server to run in an infinite loop until it crashes the browser.