topic QlikView General Questions in QlikView

QlikView General Questions

Mon, 26 Jan 2026 18:19:17 GMT

Hi There,

I have few questions which I would like to ask :

Is it possible for the QlikView app to automatically refresh itself without kicking it off or can I schedule the application to kick off on an SQL agent (SQL)
How do I hide a sheet on the application.

Thanking in advance

Treasure

Re: QlikView General Questions

Gysbert_Wassenaar — Wed, 13 Jul 2016 08:24:01 GMT

Is it possible for the QlikView app to automatically refresh itself without kicking it off or can I schedule the application to kick off on an SQL agent (SQL)
Yes. If you have Qlikview Server you can schedule the reload of a document in the QMC. If you only have Qlikview Desktop then you can create a batch file the reloads the document. You can schedule execution of that batch file with a Windows Scheduled Task.
How do I hide a sheet on the application.
Open the Sheet Properties window. On the General tab change the option under Show Sheet from Always to Conditional. Then enter 0 in the input field. Click OK to save the settings and hide the sheet. You can also use an expression to calculate the Conditional value. That way you can dynamically show or hide your sheet by having your expression calculate the result based on for example variables or selections.

Re: QlikView General Questions

Wed, 13 Jul 2016 09:24:00 GMT

thank you

Re: QlikView General Questions

Wed, 13 Jul 2016 09:34:42 GMT

Hi Wassenaar

How do I view the hidden sheets?

thanks,

Treasure

Re: QlikView General Questions

Gysbert_Wassenaar — Wed, 13 Jul 2016 09:59:41 GMT

Open the Document Properties window. Go to the Sheets tab, select your sheet and click the Properties button to open the properties window of the sheet. There change Show Sheet settings to Always.

Re: QlikView General Questions

sivasiri99 — Wed, 13 Jul 2016 10:04:15 GMT

Hi Dlamini,

In sheet property

go to Document properties>>sheets>>u can see ur sheet in status it is hidden select the sheet and go to properties

Always : it will show the sheet

condition: 0 means it will hide the sheet.

Re: QlikView General Questions

amit_saini — Wed, 13 Jul 2016 10:10:12 GMT

Hi,

Check

Thanks,

Re: QlikView General Questions

Mark_Little — Wed, 13 Jul 2016 10:11:24 GMT

or you can press ctrl+shift+s

Mark

Re: QlikView General Questions

Gysbert_Wassenaar — Wed, 13 Jul 2016 10:13:19 GMT

Not on a hidden sheet you can't.

Re: QlikView General Questions

amit_saini — Wed, 13 Jul 2016 10:17:01 GMT

Also , if u want to hide sheet from users than

Thanks,

Re: QlikView General Questions

Frank_Hartmann — Wed, 13 Jul 2016 10:18:34 GMT

This might be helpful if you are not using Server

Auto reload

Re: QlikView General Questions

Mark_Little — Wed, 13 Jul 2016 10:24:28 GMT

Hi,

Just double checked and works fine for me.

Re: QlikView General Questions

Gysbert_Wassenaar — Wed, 13 Jul 2016 10:35:17 GMT

Ah, confused it with ctrl+alt+s. Still you cannot be on a hidden sheet while pressing ctrl+shift+s either. It's hidden, so you can't be on it.

Re: QlikView General Questions

Wed, 13 Jul 2016 11:35:26 GMT

Thank you

Re: QlikView General Questions

Wed, 13 Jul 2016 11:35:44 GMT

Thank you

Re: QlikView General Questions

oknotsen — Wed, 13 Jul 2016 11:48:19 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .