topic Re: click to new sheet without button in QlikView

click to new sheet without button

Tue, 13 May 2014 20:39:05 GMT

I need to click on one cell of a column in a Straight Table (CH83) of my sheet 1 and, automatically, going to sheet 2.

How I can do this?

Can you help me, please

Best Regards

Nancy

Re: click to new sheet without button

Anonymous — Tue, 13 May 2014 21:29:28 GMT

Hi Nancy

I have looked into it myself and as far as I am aware this is not possible within Qlikview.

Bella

Re: click to new sheet without button

Tue, 13 May 2014 21:31:49 GMT

Buaaahhh!!! I'm crying!!!

Thanks Bella for your feedback

Nancy

Re: click to new sheet without button

Wed, 14 May 2014 21:23:21 GMT

Please, who can help me?

Re: click to new sheet without button

Colin-Albert — Wed, 14 May 2014 22:00:56 GMT

You can add a blank transparent text box on a layer above the layer of your chart.

Custom layers are -127 to +127 Normal is 0, Bottom -1 and Top +1.

The Action on the text box can navigate to the required sheet.

Make sure the position & size of the box is correct and the navigation works before making it transparent!

I would advise you set the caption text of the transparent text box to something like "GOTO SHXXX" - Although the caption will not be visible, it will help you find the objects when you search on the sheet properties, objects tab.

This is good practice for any transparent or conditionally hidden objects

Re: click to new sheet without button

Colin-Albert — Wed, 14 May 2014 22:07:25 GMT

You can also set the chart to be "Read Only" on the General Tab - this will disable the ability to select values by clicking on the chart - which may help with the functionality you desire.

Re: click to new sheet without button

Thu, 15 May 2014 20:55:45 GMT

Colin,

Thanks for your answer, but I need select one line of my table and, with this line selected go to other sheet with details for this line selected.

In other words, in my table on sheet 1 I have a list of project names. I need select one of these projects and, for now, I click in a buttom "Go to Detail" and go to sheet 2 which has details for this selected project.

My problem is that, for now, I can click the buttom "Go to Detail" without to select one project and sheet 2 appears messy because to appear all the projects.

Can you help me?

Thanks

Nancy

Re: click to new sheet without button

Anonymous — Thu, 15 May 2014 21:01:04 GMT

You could conditionally hide sheet 2 and the button until a selection is made in the list, or have the details infomation on sheet 1 and conditionally hide it there so it appeared when an option was selected. But there is no way to activate a sheet from a table selection.

Re: click to new sheet without button

Thu, 15 May 2014 21:09:29 GMT

The key is to not think about it as a button associated with a cell, but as an action associated with a selection. You can create a trigger than will activate the sheet if the user selects a single project number, for example. Does that help?

Re: click to new sheet without button

Thu, 15 May 2014 21:10:56 GMT

Thanks Bella!

And How can conditionally hide sheet 2 and the button until a selection is made in the list?

Thanks again

Re: Re: click to new sheet without button

Thu, 15 May 2014 21:33:43 GMT

See attached.

Re: click to new sheet without button

Thu, 15 May 2014 21:40:01 GMT

Thanks Rebecca!!!

Re: click to new sheet without button

Anonymous — Thu, 15 May 2014 21:50:50 GMT

1 – To set the sheet condition go to sheet properties > general you will see a radio button under Show Sheet

Click Conditional and add your equation in there

I use =if(GetSelectedCount(FIELD)=1,1,0)

2 – To set the button condition go to button properties and in enable condition add the same equation – this will mean the button stay there but is greyed out and not useable till a selection is made

It is possible to make the button not there but that involves variables which will take a little longer to put together an example and instructions so try this and if it doesn’t suit let me know.

Re: click to new sheet without button

Fri, 16 May 2014 14:47:07 GMT

Thanks Bella,

Re: click to new sheet without button

Fri, 16 May 2014 15:06:14 GMT

Bella:

I did it!

Thanks a lot!

Re: click to new sheet without button

NavinReddy — Wed, 19 Aug 2015 23:00:13 GMT

Thank you so much Rebecca, you application made may day

Great