Display Document Report in Report Menu only if a specific Sheet is Active

[#1]

Hi All,

This question relates to QlikView 8.5

I have two sheet tabs, each of which require different default selections - 1. YTD Sales by week and 2. Mth Sales by Day
Then I have two reports in the Report menu - 1. YTD Sales by Week and 2. Mth Sales by Day.
Because each of the two report require different period parameters to work correctly I set those parameters when the sheet tabs are selected (or activated) by User eg for YTD Sales by Week I use 'OnActiveSheet' macro to select current year and de-select Qtr, Month, Week and Day but for Mth Sales by Day I use 'OnActiveSheet' macro to select current year and current month but de-select Qrt and Day

The thing is that I do not want the Mth Sales by Day report to be visible in the menu bar if the Mth Sales by Day is not Active nor do I want the YTD Sales by week to be visible if the YTD Sales by week sheet tab is not active. Otherwise incorrect period selections are active

I see that there is a conditional show option in the report settings but I do not know the script to place in there eg OnActiveSheet('SH22')

The sheet id's are SH22 and SH23

I appreciate your support.. Thanks, Raisin

[#2 · Accepted solution]

Never mind, took some time but I've found the answer myself.

I place the following function/script in the 'Conditional Show' setting of the reports.

For the YTD report:
GetActiveSheetId()='Document\SH22'

For the Month report:
GetActiveSheetId()='Document\SH23

and now the reports only show up in the Reports menu when the relevant sheets are active

/Raisin