Sheet ID and Sheet Name

[#1]

Hi,

how can I get via Formula the Sheet ID and the Sheet Name in the tab?

The below shown does not work. Every Sheet shall be like "SHxx Name of Sheet" (no matter if it is active or not)

Thanks in advance.

Chris

[arulsettu]

may be this

=GetActiveSheetId()&'Dashboard'

[#3]

Hi Arul,

I thought of that too but when I Change the active sheet the SH-number changes too 😞

Is there a calculation for getsheetid?

Chris

[#4]

Hi,

you have to use =GetActiveSheetId()

[Anonymous]

To get the Sheetid by using this one =GetActiveSheetId()

[swuehl]

I don't think so, so you probably Need

='SH01 Dashboard'

or

SH01 Dashboard

[arulsettu]

check this it would help

List All Sheets Within a QVW file | Qlik Community

[#8]

If(Qvuser='ADMIN' OR Qvuser= 'SH01',0,1) apply this Condition