topic Re: QlikView sheet Optimize in QlikView

QlikView sheet Optimize

Fri, 20 Nov 2020 18:02:30 GMT

Hi Experts,

Quick question in my application qvw file contains 16 sheets but I would like to show 4 sheets including objects how do I hide the sheets in my app? Can anyone throw some light on this

Thanks,

Re: QlikView sheet Optimize

Gysbert_Wassenaar — Wed, 20 Jan 2016 16:39:23 GMT

You can use the Show Sheet option on the General tab of the properties window of the sheet to show or hide a sheet. If you select the Conditional option you can enter an expression that returns a numeric value. To hide the sheet make the expression return 0. To show the sheet make the expression return any number that isn't 0. So if you want to permanently hide them simply use 0 as the conditional expression.

Re: QlikView sheet Optimize

andrespa — Wed, 20 Jan 2016 16:39:32 GMT

Hi Verendra, you can go to sheet properties>general>conditional=0 Do this for each sheet you want to hide.

Hope it helps.

Cheers,

Andrés

Re: QlikView sheet Optimize

Wed, 20 Jan 2016 16:46:38 GMT

You can hide the sheet by Sheer Properties --> General --> Show Sheet --> Conditional --> write your conditions

Based on conditions & selections, you can show only 4 sheets at a given time.

Re: QlikView sheet Optimize

engishfaque — Thu, 21 Jan 2016 04:14:26 GMT

Dear Verendra,

Kindly find attached App, I hope you are looking for that one solution.

Kind regards,

Ishfaque Ahmed

Re: QlikView sheet Optimize

Thu, 21 Jan 2016 13:26:31 GMT

Folks,

Thank you all for taking your time.

Thanks a lot. It works.

Kind regards,

Verendra

Re: QlikView sheet Optimize

Thu, 21 Jan 2016 13:31:22 GMT

Hi Ishfaque Ahmed,

Thank you for your examples it's really helpful the which you sent me. Spot on...

Kind regards,

Verendra.

Re: QlikView sheet Optimize

Thu, 21 Jan 2016 16:29:17 GMT

Hi Gysbert,

Thanks a lot.It works

Kind regards,

Verendra