topic Re: How to use GetActiveSheetID() to hide a conditional chart in QlikView

How to use GetActiveSheetID() to hide a conditional chart

Tue, 22 Oct 2013 19:57:20 GMT

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!

Re: How to use GetActiveSheetID() to hide a conditional chart

MayilVahanan — Tue, 22 Oct 2013 20:03:13 GMT

=GetActiveSheetId() gives Document/SH04

So i think you want to use like this

=GetActiveSheetId() = 'Document\SH02' and GetSelectedCount(Question) > 0

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

Can you explain in detail. Its make little bit confusion.

Re: How to use GetActiveSheetID() to hide a conditional chart

Tue, 22 Oct 2013 20:18:10 GMT

Thanks for the reply. I think I have some other issue that is causing this problem.

So, I'll try to explain. There are 4 tabs (sheets) in this document. The conditional charts are only supposed to show up on Sheet 4. Instead, they show up on tab 2, 3 and 4 when the condition is met. this still happens even when I add the

getactivesheetid() = 'Document\SH04'

I copied Sheet 2 to make Sheet 3 & 4. Note that the box doesn't show up on Sheet 1. So, I feel like there is some condition that I created when copying the sheets that is causing or contributing to the issue. Thanks for your help.

Re: Re: How to use GetActiveSheetID() to hide a conditional chart

MayilVahanan — Tue, 22 Oct 2013 20:50:53 GMT

PFA

Hope it helps