topic Re: Jump to ___ in sheet ? in QlikView

Jump to ___ in sheet ?

Wed, 28 Aug 2013 12:32:42 GMT

Hi,

I build a very long page with many tables. The layout needs to remain this way for various reasons, but the tables themselves fall under different categories. What I'm asking is if there's a way to create a button (or any other solution) that by clicking it the view will jump to a specific section of the sheet, (something like you will see in many websites) ?

Thanks

Re: Jump to ___ in sheet ?

fernando_tonial — Wed, 28 Aug 2013 12:40:00 GMT

You can try use the actions in the button object.

Best Regards.

Tonial.

Re: Jump to ___ in sheet ?

Anonymous — Wed, 28 Aug 2013 13:23:58 GMT

Hi,

you can create a button, then make it activate a variable something like =if(vShow=1,0,1)

and on the table layout you chose the condition that shows the table

setting variables is under setting-->variable overview

hope that helped

Re: Jump to ___ in sheet ?

Anonymous — Wed, 28 Aug 2013 13:29:40 GMT

Hi,

Can you please explain detail what you needed.

Thanks

Re: Jump to ___ in sheet ?

marcus_sommer — Wed, 28 Aug 2013 13:33:11 GMT

You should separate your objects in several sheets. Within the sheets you could put the objects one above the other and controled the visibility per variable (settings in layout) and/or put the opbjects in container-boxes which could also be nested. This could you control per macros or actions in buttons which choose the sheet or perhaps bookmark and/or set variable-values and so on. If you have any scroll-bars the usability isn't really good ...

- Marcus

Re: Jump to ___ in sheet ?

Wed, 28 Aug 2013 13:48:55 GMT

All, thanks for trying to help.

What I have is one long sheet with many pivot tables one below the other.

This has to remain the format.

I cannot break it to different sheets or to use conditional show/hide.

That's why I asked how I can get a "jump to" functionality, for places within the same sheet.

Thanks

Re: Jump to ___ in sheet ?

Wed, 28 Aug 2013 14:04:30 GMT

please see below

Re: Jump to ___ in sheet ?

Wed, 28 Aug 2013 14:04:34 GMT

please see below

Re: Jump to ___ in sheet ?

Wed, 28 Aug 2013 14:04:57 GMT

please see below

אבנר ?

Re: Jump to ___ in sheet ?

marcus_sommer — Wed, 28 Aug 2013 14:42:52 GMT

I Think this isn't possible, it isn't a native functionality in qv. Which advantages have you with several large tables on one sheet?

- Marcus

Re: Jump to ___ in sheet ?

MayilVahanan — Wed, 28 Aug 2013 14:51:51 GMT

you can show/hide the charts based on the button selection instead jump over to that charts in same sheet.

Same like jump in the website..

Hope that helps

Re: Jump to ___ in sheet ?

Wed, 28 Aug 2013 15:19:28 GMT

Please see earlier comment I posted

thanks

Re: Jump to ___ in sheet ?

Wed, 28 Aug 2013 15:19:59 GMT

Well.... sometimes the people that pay your monthly salary ask for things to be done a certain way

Re: Jump to ___ in sheet ?

Anonymous — Thu, 29 Aug 2013 04:19:58 GMT

כן

Re: Jump to ___ in sheet ?

marcus_sommer — Thu, 29 Aug 2013 06:37:25 GMT

Well that's happens - but what is the aim? Is it important enough you could ask QV to customize your environment.

- Marcus

Re: Jump to ___ in sheet ?

Thu, 29 Aug 2013 12:33:50 GMT

The aim is to replace excel. where this long sheet of tables and cross calculations thrive.

Why would QV do that?

Re: Jump to ___ in sheet ?

Thu, 29 Aug 2013 12:34:06 GMT

מגניב. אתה מכיר קבוצות מקומיות של משתמשי קליקויו?

Re: Jump to ___ in sheet ?

marcus_sommer — Thu, 29 Aug 2013 12:41:18 GMT

Why not - the most things could be done in qv equally as in excel (often better).

- Marcus

Re: Jump to ___ in sheet ?

Anonymous — Thu, 29 Aug 2013 12:51:09 GMT

לצערי לא. לא מצאתי כאן בקבוצות

Re: Jump to ___ in sheet ?

Thu, 29 Aug 2013 12:55:51 GMT

maybe I don't understand you right...

why would QV adhere to my whims?