topic Re: In-Built GetSlelctions() Function in QlikView

In-Built GetSlelctions() Function

sujeetsingh — Thu, 09 Jan 2014 05:29:17 GMT

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?

Re: In-Built GetSlelctions() Function

Siva_Sankar — Thu, 09 Jan 2014 05:38:04 GMT

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

Re: In-Built GetSlelctions() Function

Thu, 09 Jan 2014 05:38:43 GMT

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

Re: Re: In-Built GetSlelctions() Function

Siva_Sankar — Thu, 09 Jan 2014 05:42:38 GMT

PFA

Re: In-Built GetSlelctions() Function

senpradip007 — Thu, 09 Jan 2014 05:44:14 GMT

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

Re: In-Built GetSlelctions() Function

sujeetsingh — Thu, 09 Jan 2014 06:10:35 GMT

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 .

Re: In-Built GetSlelctions() Function

Thu, 09 Jan 2014 06:15:49 GMT

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

Re: In-Built GetSlelctions() Function

sujeetsingh — Thu, 09 Jan 2014 08:12:18 GMT

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.