topic Re: Is it possible to retrieve a sheet's Show Condition property using APIs? in Integration, Extension & APIs

Is it possible to retrieve a sheet's Show Condition property using APIs?

stascher — Wed, 03 Sep 2025 16:38:11 GMT

Hello,

We're looking for a way to programmatically detect if a sheet has the ability to be hidden based on the existence of a Show Condition expression. I know we can obtain lists of sheets using APIs, but can we obtain this property on individual sheets through APIs as well?

Thanks,

Steven

Re: Is it possible to retrieve a sheet's Show Condition property using APIs?

rwunderlich — Wed, 03 Sep 2025 18:04:29 GMT

Yes you can. It's the "showCondition" property in the Sheet Properties.

-Rob

Re: Is it possible to retrieve a sheet's Show Condition property using APIs?

hugo_andrade — Wed, 03 Sep 2025 20:35:52 GMT

Hi @stascher ,

How are you getting the Sheet IDs? Which API are you using?

We can help you get all the way to the sheet property.

Are you on Qlik Sense on Windows or Qlik Cloud?

Re: Is it possible to retrieve a sheet's Show Condition property using APIs?

Øystein_Kolsrud — Thu, 04 Sep 2025 08:41:09 GMT

As @rwunderlich says, that information is available in the sheets properties structure. You will have to go through the Engine API to retrieve that.

https://qlik.dev/apis/json-rpc/qix/

This is what the structure looks like: