topic Re: controlling the loop in QlikView

controlling the loop

Anonymous — Fri, 17 Oct 2014 09:27:09 GMT

Hi,

I am new to VB Scripting in the edit Module and need you help.

I need the loop for the export ppt to be controlled. I could able to export the sheets to PPT but unfortunately same sheets are repeating.

Suggest me how to control the loop

Re: controlling the loop

d_pranskus — Fri, 17 Oct 2014 10:01:11 GMT

Your problem is that you loop through all your sheets and then you export the objects from all sheets in each iteration.

You need to export just the objects from the sheet of current loop iteration.

Cheers

Re: controlling the loop

Anonymous — Fri, 17 Oct 2014 10:09:43 GMT

Thanks Darius for response

I am trying to do the same thing but unfortunately I cannot achieve the result

I need the selected sheet objects from all the sheets to be exported

can you share me the sample app

would be grateful

Re: Re: controlling the loop

d_pranskus — Fri, 17 Oct 2014 11:24:01 GMT

Please see attached

Also on the last sheet there is a search object which for some reason is not copied to clipboard properly, that's why the statistic box is copied twice. This seems to be qv bug at least in the version I have.

Re: controlling the loop

Anonymous — Fri, 17 Oct 2014 11:34:04 GMT

Thanks for the sharp solution

but still some suggestions required there are 3 sheets but in PPT we are getting 7 slides and also I need not to get the PPT button to be exported

The same sheets objects to be placed in one Slide in the PPT (3Sheets to the 3 slides )

Kindly suggest on the same.

Hoping response from you

Re: controlling the loop

d_pranskus — Fri, 17 Oct 2014 11:36:55 GMT

Could this be of some help? http://community.qlik.com/docs/DOC-3774

Re: controlling the loop

Anonymous — Sat, 18 Oct 2014 18:31:05 GMT

This may resolve your issue or help to point you in the right direction.

see attached.

Re: Re: controlling the loop

Anonymous — Sun, 19 Oct 2014 07:25:15 GMT

Thanks autopilot

for your immense help.

you solved my problem almost but a minor correction could you let me know the positions of the object in a proper way. as they are coincided one on other

I am a beginner in VB , so that I could not able to figure out where the changes are to be made.

My user needs the objects position to be as same as in the QV dashboard
Hoping a positive feedback from your end.

Re: Re: Re: controlling the loop

Anonymous — Mon, 20 Oct 2014 03:57:13 GMT

Thanks autopilot for your immense help.

you solved my problem almost but a minor correction needed .

I am sharing an exact requirement app in that I need the entire Main sheet , and in Sheet 1 and sheet 2 the pivot table and table boxes only to be exported to PPT

could you let me know how to set the positions of the object in a proper way .

I am a beginner in VB , so that I could not able to figure out where the changes are to be made.

My user needs the objects position to be as same as in the QV dashboard
Hoping a positive feedback from your end. (Share me the sample please)

Re: Re: Re: Re: controlling the loop

Anonymous — Mon, 20 Oct 2014 15:00:11 GMT

To adjust the shapes position in powerpoint, focus on lines 29 - 35 in the macro script.

iterno = 1

for each shape in PPSlide.Shapes

with shape

.top = 1 * iterno

.left = 1

end with

iterno = iterno * 270

Re: Re: Re: Re: controlling the loop

Anonymous — Mon, 20 Oct 2014 15:58:35 GMT

Thanks autopilot

with this code I could only able to adjust the only one sheet object in each slide.

but I need to adjust all the sheet objects

could you let me know how to apply the same for more than one sheet objects