Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QlikView sheet Optimize

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

7 Replies
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.


talk is cheap, supply exceeds demand
andrespa
Specialist
Specialist

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

Not applicable
Author

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
Specialist III
Specialist III

Dear Verendra,

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

Kind regards,

Ishfaque Ahmed

Not applicable
Author

Folks,

Thank you all for taking your time.

Thanks a lot. It works.


Kind regards,

Verendra

Not applicable
Author

Hi Ishfaque Ahmed,

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

Kind regards,

Verendra.

Not applicable
Author

Hi Gysbert,

Thanks a lot.It works

Kind regards,

Verendra