topic Re: Generate each qlikview object (Sheet) to Excel in reverse order in QlikView

Generate each qlikview object (Sheet) to Excel in reverse order

trdandamudi — Fri, 18 Mar 2016 13:52:44 GMT

I have three pivot objects in my qlikview and trying to export them to excel in a order. Example: I have three charts as CH-1, CH-2 and CH-3. It is generating the sheets but it is generating in reverse order like CH-3, CH-2 and CH-1.

I want the sheets to be generated like CH-1, CH-2 and CH-3.

FOR y = lBound(Objects) To uBound(Objects) <----------- If I use this code it generates them as CH-3, CH-2, CH-1

FOR y = lBound(Objects) To uBound(Objects) step -1 <---- if I use this code it generates an empty file.

Am I missing something here ?

Re: Generate each qlikview object (Sheet) to Excel in reverse order

m_woolf — Fri, 18 Mar 2016 14:40:12 GMT

FOR y = UBound(Objects) To IBound(Objects) step -1

Re: Generate each qlikview object (Sheet) to Excel in reverse order

trdandamudi — Fri, 18 Mar 2016 14:46:47 GMT

I added your line of code but it still does it in reverse order.

I have the following charts:

Chart-300

Chart-310

Chart-320

It is generating the tabs as chart-320, Chart-310, Chart-300 ?

Re: Generate each qlikview object (Sheet) to Excel in reverse order

m_woolf — Fri, 18 Mar 2016 15:17:57 GMT

Why not loop through the Object IDs instead?

Something like:

for y = 300 to 320 step 10

Application.GetSheetObject("chart-" & y)