3 Replies Latest reply: Oct 22, 2013 4:50 PM by Mayil Vahanan Ramasamy RSS

    How to use GetActiveSheetID() to hide a conditional chart

    Ken Hill

      Hi - first time poster here and still pretty new to the wonderful world of QV


      I have a chart which I'm using as a "drill" so it only appears when the user makes a certain selection.  The expression is:


      len(getFieldSelections(Question)) > 0


      However, this makes the chart visible across all 4 sheets in my QVW.  I only want it to appear on the "home" sheet.


      I thought adding the condition GetActiveSheetID() = 'SH04' to the above would do the trick but it didn't work.    The sheet is always hidden in that case even though I verified that the sheet ID is SH04 (at least that is what the properties tells me it is)


      Am I barking up the wrong tree?  Is there a way to find out the value of GetActiveSheetID() is at any given time?  Is there a better way to do this?


      Thanks in advance!