Qv.Document.GetObject never completes for pivot charts when the Pagesize.x is greater 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.
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.
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.