QlikView sheet Optimize

[#1]

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,

V

[Gysbert_Wassenaar]

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.

[andrespa]

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

[#4]

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.

[engishfaque]

Dear Verendra,

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

Kind regards,

Ishfaque Ahmed

[#6]

Folks,

Thank you all for taking your time.

Thanks a lot. It works.

Kind regards,

Verendra

[#7]

Hi Ishfaque Ahmed,

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

Kind regards,

Verendra.

[#8]

Hi Gysbert,

Thanks a lot.It works

Kind regards,

Verendra