topic Hidden Sheet Information in QlikView https://community.qlik.com/t5/QlikView/Hidden-Sheet-Information/m-p/700977#M1076036 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; font-size: 14px;">getsheetbyId can be used to access a hidden sheet but for that we need sheetid.</SPAN></P><P><SPAN style="color: #000000; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; font-size: 14px;">like:</SPAN></P><P><SPAN style="color: #000000; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; font-size: 14px;">ActiveDocument.GetSheetByID("SH03");</SPAN></P><P><SPAN style="color: #000000; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; font-size: 14px;">How to get the sheet id's corresponding to each sheet in a qlikview Document.</SPAN></P></BODY></HTML> Thu, 17 Jul 2014 19:06:04 GMT 2014-07-17T19:06:04Z Hidden Sheet Information https://community.qlik.com/t5/QlikView/Hidden-Sheet-Information/m-p/700977#M1076036 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; font-size: 14px;">getsheetbyId can be used to access a hidden sheet but for that we need sheetid.</SPAN></P><P><SPAN style="color: #000000; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; font-size: 14px;">like:</SPAN></P><P><SPAN style="color: #000000; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; font-size: 14px;">ActiveDocument.GetSheetByID("SH03");</SPAN></P><P><SPAN style="color: #000000; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; font-size: 14px;">How to get the sheet id's corresponding to each sheet in a qlikview Document.</SPAN></P></BODY></HTML> Thu, 17 Jul 2014 19:06:04 GMT https://community.qlik.com/t5/QlikView/Hidden-Sheet-Information/m-p/700977#M1076036 2014-07-17T19:06:04Z Re: Hidden Sheet Information https://community.qlik.com/t5/QlikView/Hidden-Sheet-Information/m-p/700978#M1076037 <HTML><HEAD></HEAD><BODY><P>go to document properties -&gt; sheets</P><P></P><P>that will give you the Id's to work with</P></BODY></HTML> Thu, 17 Jul 2014 19:20:49 GMT https://community.qlik.com/t5/QlikView/Hidden-Sheet-Information/m-p/700978#M1076037 2014-07-17T19:20:49Z Re: Hidden Sheet Information https://community.qlik.com/t5/QlikView/Hidden-Sheet-Information/m-p/700979#M1076038 <HTML><HEAD></HEAD><BODY><P>But I need a macro for this</P></BODY></HTML> Thu, 17 Jul 2014 20:12:55 GMT https://community.qlik.com/t5/QlikView/Hidden-Sheet-Information/m-p/700979#M1076038 2014-07-17T20:12:55Z