topic Bug with a Attach/Detach PivotTables? in QlikView https://community.qlik.com/t5/QlikView/Bug-with-a-Attach-Detach-PivotTables/m-p/279952#M1203271 <HTML><HEAD></HEAD><BODY><P>Objects that are minimized or on another sheet are never calculated this is to optimize performance (only calculate what you can see).</P></BODY></HTML> Fri, 01 Oct 2010 12:59:47 GMT kji 2010-10-01T12:59:47Z Bug with a Attach/Detach PivotTables? https://community.qlik.com/t5/QlikView/Bug-with-a-Attach-Detach-PivotTables/m-p/279950#M1203269 <HTML><HEAD></HEAD><BODY><P>Have a very strange behavior in my Project. I have Sheet1 and sheet2. On Sheet1 exists button with an action Exec Macro DoRep</P><P>On Sheet2 two PivotTables. That's macros:</P><P>sub DoRep</P><P>set doc=ActiveDocument<BR />set sh1=doc.GetSheetObject("chart1")<BR />set sh2=doc.GetSheetObject("chart2")<BR />set fie=doc.fields("field1")<BR /><BR />sh2.Attach<BR />doc.GetApplication.WaitForIdle<BR />fie.Select "Cav"<BR />fie.ToggleSelect "Fish"<BR />fie.ToggleSelect "Cat"<BR />fie.ToggleSelect "Dog"<BR />'doc.recalldocbookmark "Table1"<BR />doc.GetApplication.WaitForIdle<BR />sh2.Detach<BR /><BR />sh1.Attach<BR />doc.GetApplication.WaitForIdle<BR />fie.Select "Carrot"<BR />fie.ToggleSelect "Mouse"<BR />fie.ToggleSelect "Rat"<BR />'doc.recalldocbookmark "Table2"<BR />doc.GetApplication.WaitForIdle<BR />sh1.Detach<BR /><BR /><BR />end sub<BR /><BR /> Such a problem - if button belongs Sheet1 - macros doesnt makes correctly result, only if button on sheet2 all correct</P><P></P><P>Can You help me?</P></BODY></HTML> Fri, 01 Oct 2010 11:49:34 GMT https://community.qlik.com/t5/QlikView/Bug-with-a-Attach-Detach-PivotTables/m-p/279950#M1203269 2010-10-01T11:49:34Z Bug with a Attach/Detach PivotTables? https://community.qlik.com/t5/QlikView/Bug-with-a-Attach-Detach-PivotTables/m-p/279951#M1203270 <HTML><HEAD></HEAD><BODY><P>Even if button and tables belongs to the same sheet, but tables are minimized problem exists <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P></BODY></HTML> Fri, 01 Oct 2010 12:00:44 GMT https://community.qlik.com/t5/QlikView/Bug-with-a-Attach-Detach-PivotTables/m-p/279951#M1203270 2010-10-01T12:00:44Z Bug with a Attach/Detach PivotTables? https://community.qlik.com/t5/QlikView/Bug-with-a-Attach-Detach-PivotTables/m-p/279952#M1203271 <HTML><HEAD></HEAD><BODY><P>Objects that are minimized or on another sheet are never calculated this is to optimize performance (only calculate what you can see).</P></BODY></HTML> Fri, 01 Oct 2010 12:59:47 GMT https://community.qlik.com/t5/QlikView/Bug-with-a-Attach-Detach-PivotTables/m-p/279952#M1203271 kji 2010-10-01T12:59:47Z