topic Conditional display of sheet in version 8.5 in QlikView https://community.qlik.com/t5/QlikView/Conditional-display-of-sheet-in-version-8-5/m-p/171508#M41484 <HTML><HEAD></HEAD><BODY><P>Thanks but if I use the sheet properties and then I change the selection by macro it seems tio lose the conditional expression.</P><P>For this reason I wan to tom tray to defibne the expression for conditional display by using a Imacro.</P><P>I've found this example</P><P style="text-align: left"></P><P></P><P style="text-align: left"></P><P style="text-align: left"></P><P style="text-align: left"></P><P style="text-align: left"></P><P style="text-align: left"></P><P style="text-align: left"></P><BR /><BR /> <P style="text-align: left"></P><P style="text-align: left"></P><P></P><P style="text-align: left">set mysheet=ActiveDocument.ActiveSheet<BR />set sp=mysheet.GetProperties<BR />sp.ShowAlways = false<BR />sp.ShowExpression = "sum(Sales)&gt;4000"<BR />mysheet.SetProperties sp</P><P style="text-align: left">but it don't work in my version.</P><P style="text-align: left"></P><P style="text-align: left"></P><BR /><BR /></BODY></HTML> Tue, 09 Mar 2010 07:49:36 GMT 2010-03-09T07:49:36Z Conditional display of sheet in version 8.5 https://community.qlik.com/t5/QlikView/Conditional-display-of-sheet-in-version-8-5/m-p/171506#M41482 <HTML><HEAD></HEAD><BODY><P>It is possible to use a macro for hide or display a sheet with conditional expression?</P><P>Thanks</P><P>Master</P></BODY></HTML> Mon, 08 Mar 2010 16:07:42 GMT https://community.qlik.com/t5/QlikView/Conditional-display-of-sheet-in-version-8-5/m-p/171506#M41482 2010-03-08T16:07:42Z Conditional display of sheet in version 8.5 https://community.qlik.com/t5/QlikView/Conditional-display-of-sheet-in-version-8-5/m-p/171507#M41483 <HTML><HEAD></HEAD><BODY><P>If you right hand click and go to the sheet properties.. Then layout.. you can set your condition for being able to view the sheet.</P><P></P></BODY></HTML> Mon, 08 Mar 2010 16:50:10 GMT https://community.qlik.com/t5/QlikView/Conditional-display-of-sheet-in-version-8-5/m-p/171507#M41483 2010-03-08T16:50:10Z Conditional display of sheet in version 8.5 https://community.qlik.com/t5/QlikView/Conditional-display-of-sheet-in-version-8-5/m-p/171508#M41484 <HTML><HEAD></HEAD><BODY><P>Thanks but if I use the sheet properties and then I change the selection by macro it seems tio lose the conditional expression.</P><P>For this reason I wan to tom tray to defibne the expression for conditional display by using a Imacro.</P><P>I've found this example</P><P style="text-align: left"></P><P></P><P style="text-align: left"></P><P style="text-align: left"></P><P style="text-align: left"></P><P style="text-align: left"></P><P style="text-align: left"></P><P style="text-align: left"></P><BR /><BR /> <P style="text-align: left"></P><P style="text-align: left"></P><P></P><P style="text-align: left">set mysheet=ActiveDocument.ActiveSheet<BR />set sp=mysheet.GetProperties<BR />sp.ShowAlways = false<BR />sp.ShowExpression = "sum(Sales)&gt;4000"<BR />mysheet.SetProperties sp</P><P style="text-align: left">but it don't work in my version.</P><P style="text-align: left"></P><P style="text-align: left"></P><BR /><BR /></BODY></HTML> Tue, 09 Mar 2010 07:49:36 GMT https://community.qlik.com/t5/QlikView/Conditional-display-of-sheet-in-version-8-5/m-p/171508#M41484 2010-03-09T07:49:36Z