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.
may be this
I thought of that too but when I Change the active sheet the SH-number changes too :-(
Is there a calculation for getsheetid?
I don't think so, so you probably Need
check this it would help
List All Sheets Within a QVW file | Qlik Community
you have to use =GetActiveSheetId()
To get the Sheetid by using this one =GetActiveSheetId()
If(Qvuser='ADMIN' OR Qvuser= 'SH01',0,1) apply this Condition
Retrieving data ...