topic Re: Sheet ID literal help needed? in QlikView

Sheet ID literal help needed?

Mon, 08 Jun 2015 11:41:19 GMT

Hi,

I wanna conditionally display text when Sheet ID = SH01. QV is throwing error that Sheet ID is not a valid literal can you please help to achieve this functionality?

Re: Sheet ID literal help needed?

rubenmarin — Mon, 08 Jun 2015 11:44:18 GMT

Hi, maybe this can help you to check the ID of the Sheet:

Subfield(GetActiveSheetId(), '\', 2)='SH01'

Re: Sheet ID literal help needed?

Kushal_Chawda — Mon, 08 Jun 2015 11:46:40 GMT

Which condition you are using?

Re: Sheet ID literal help needed?

Mon, 08 Jun 2015 11:48:55 GMT

Hi,

Objects are specific to sheets.So if we are viewing 1 sheet(which has a particular sheet ID),objects for that sheet will be visible.So why do we require to define a condition to view a txt based on sheet ID.

Please explain your requirement if I am wrong

Regards,

Jemimah

Re: Sheet ID literal help needed?

prashantbaste — Mon, 08 Jun 2015 11:52:01 GMT

Please try below syntax -

=If(GetActiveSheetId()='Document\SH01','Text Message)

Let me know if it resolves your query.

Regards,

Prashant P Baste

Re: Sheet ID literal help needed?

Mon, 08 Jun 2015 11:56:03 GMT

Jemimah! You are right. Now I changed my thoughts but My question was all about getactivatedsheet() function. earlier I do not know about this