Field Selction and Sheet Activation

[qlik_venu]

Hi,

I have a requirement where i need to do something similar to a drill through. and since we cant have a drill through based on the chart bars, we have provided a button which will link this to the Detail level sheet.

I have created this button to activate the detail sheet. But before opening the detail sheet, we also need to check if a  particular field, (CLASS) has atleast one value which has been selected. Without this selection the detal sheet should not get activated. And on clicking the button (EXPENSE CHART SUMMARY SHEET) should display a message saying to select a field  (CLASS) value.

I also need to hide the Detail sheet. It should be made visible only clicking the button. (EXPENSE CHART SUMMARY) .

Please guide me in this.

Thanks,

Venu

[#2]

For the first part of your question: Put a conditional check for the value of CLASS with GetFieldSelection().

For the second part: create a variable. on Action of the button that you've created assign the value "EXPENSE CHART SUMMARY SHEET" to this variable. And  conditionally show the chart (by checking if the value is EXPENSE.....) Once you are on teh Detail Sheet, put another button to get Back to the summary sheet by inverting the variable assignments.

[#3]

Another option for only displaying the sheet is to set the Show sheet conditional property to GetActiveSheetId()='Document\SH09'

And you would replace SH09 with your sheet name. This will make it hidden unless you are currently on it. If you button activates it then it should show up, then as soon as another sheet is selected, disappear.

[qlik_venu]

hi,

thanks for the reply.

I tried this option.

But the sheet is never getting activated. Even though i tried to actavte

through the button Actions, it was getting conditionaly blocked by

GetActiveSheetId()='Document\SH07' .

I had given the sheet number properly, but not sure why I am missing it.

Thanks,

Venu

On Fri, Oct 21, 2011 at 12:21 AM, marcsliving <

[qlik_venu]

hi,

Thanks for the reply.

its all working fine, but only the last part is havnig an issue.

The detail sheet opens up based on the variable condition. But we have to

definelty use the "back to the summary" button to reset the variable. When i

just select a different tab directly without using the Button, the sheet is

still Visible ( but not active). I dont want the detail sheet to be seen in

the tab also.

Any suggestions.

Thanks,

Venu

On Thu, Oct 20, 2011 at 11:56 PM, JasleenP_SR <

[#6 · Accepted solution]

Hi Venu: I've put some buttons and sheets in the attached qvw. check it out..hopefully this'll help you.

[qlik_venu]

Thanks, resetting the variable onleaving the sheet, helped.

Venu