topic Re: sheetid in QlikView

sheetid

NavinReddy — Wed, 05 Mar 2014 07:22:39 GMT

Dear All, How can i get my sheetid , i want to create one variable i need to assign sheet id to that variable Best Regards, Niranjan

Re: sheetid

MK_QSL — Wed, 05 Mar 2014 07:24:11 GMT

GetActiveSheetID()

Re: sheetid

Wed, 05 Mar 2014 07:26:35 GMT

go to sheet properties an have look at image

Re: sheetid

Wed, 05 Mar 2014 07:26:58 GMT

Hi,

You can simply right click on your sheet, go to Properties--Genral tab and you will find Sheet ID there.

Or you can use GetActiveSheetID() function in a text box as suggested by Manish to get Sheet ID.

Hope this helps!

Re: Re: sheetid

NavinReddy — Wed, 05 Mar 2014 07:28:45 GMT

Hi manish,

That gives Document\SH01

how can i get only SH01

Thank you so much for reply

Regards,

Niranjan

Re: sheetid

jagan — Wed, 05 Mar 2014 07:28:47 GMT

Hi,

Try GetActiveSheetID(), will give you the Current sheet ID.

vCurrentSheetID = GetActiveSheetID()

Regards,

Jagan.

Re: sheetid

MK_QSL — Wed, 05 Mar 2014 07:31:35 GMT

=SubField(GetActiveSheetId(),'\',2)

Re: sheetid

NavinReddy — Wed, 05 Mar 2014 07:32:21 GMT

Hi Jagan,

That gives Document\SH01

how can i get only SH01

Regards,

Niranjan

Re: Re: sheetid

jagan — Wed, 05 Mar 2014 07:32:50 GMT

Hi,

Try this

=SubField(GetActiveSheetId(),'\',2)

Regards,

Jagan.

Re: Re: sheetid

Wed, 05 Mar 2014 07:36:13 GMT

=SubField(GetActiveSheetId(),'\',2)

Re: sheetid

sunilkumarqv — Wed, 05 Mar 2014 07:57:13 GMT

Hi Niru,

Try Like this to get current sheet ID

Let vCurrentSheetID =SubField(GetActiveSheetId(),'\',2);