In-Built GetSlelctions() Function

[sujeetsingh]

Hello All ,

What is the valid syntax of GetCurrentSelections() function.

Let there be a button and i what the sheet to be active when the button is clicked.

Any idea?

[Siva_Sankar]

Create a button, right click button, go to button properties,actions tab, add and select layout,activate sheet.In the sheet id mention the sheet id you want to activate. it helps your need.

Regards.

siva

[#3]

Hi Sujeet,

  Your question is getcurrentselections syntax or how active the sheet on button click event.

  Anyway if you want syntax of getcurrentselections() will find from Help of qlikview desktop. go to Help menu click on help and type the getcurrentselections().

  For Activate next sheet please find attached document

[Siva_Sankar]

PFA

[senpradip007]

Hi

you can set an action of ActiveSheet() in that button to achieve your goal.

[sujeetsingh]

Hello my fault, actually i do not want the sheet to just get activated on a click of a button ,actually i want two or more sheet to be hidden and when a button is selected then it be active.(Please avoid using the variables because it may get complex when i will be having many such actions and buttons .

[#7]

Hi Sujeet,

  Using a variable value and conditional show option of sheet you can achieve this.

   Step1 ) In button Take a Set Variable action give a value as 1

   Step 2) Call this Variable in Conditional Show of General Tab.

Santhosh G

[sujeetsingh · Accepted solution]

Actually it seems that without the variables it is not possible.

Actually i was thinking of any way to link this with the action or clicking of the button.

Thanks for your replies gentlemen.