topic Re: How to keep sheets in different tabs in QlikView

How to keep sheets in different tabs

Wed, 02 Apr 2014 12:30:43 GMT

Hi, i have a QVW file where all the sheets are available in single tab by changing the drop down. lets say sheet1, sheet2 sheet3 etc all these sheets are available in drop down option in the single tab. now i need to remove this drop down and need to keep sheets in different tabs, can anyone please help me to change this

Re: How to keep sheets in different tabs

maxgro — Wed, 02 Apr 2014 12:36:19 GMT

do you mean you only have one sheet without tab?

in menù

settings --> docuemt properties --> general --> uncheck hide tabrow

Re: How to keep sheets in different tabs

its_anandrjs — Wed, 02 Apr 2014 12:54:02 GMT

Hide your tabrow by

Settings >> Document properties >> General >> Uncheck Hide tabrow

and for menu selection take three text object

for 1st text object >> in action >> add action >> Layout >> Activate Sheet >> then type Sheet ID (SH02) what ever sheet you want to open.

do same for other text objects

Hope this helps

Re: How to keep sheets in different tabs

Thu, 03 Apr 2014 03:48:58 GMT

Wow thats great !! i got it...........Thank you so much Anand.......

I have one more requirement, altogether i have 10 sheet tabs in my QVW file which i want to divide into 2 QVW files, could you please suggest me how to do this.....