topic Required sheet is not appears directly in button click in QlikView

Required sheet is not appears directly in button click

Wed, 29 Feb 2012 20:01:52 GMT

Hi All,

Please check my sample application.

The problem i am getting like

In my app there are 3 buttons.if i click any of the buttons that corresponding pages should open.

The action is happening like below

1->2 Sheets should appear all the time.

2->In the 2nd sheet if i select any of the button that corresponding page should open.

3->After clicking the button in 2nd sheet it went to Home sheet.

4->Again if i seelct the second sheet the step2 is happening.

5->This is happening for all the buttons.

I don't know why it behaves like that.

Please let me know if any one knows the reason.

Thanks in advance....

Re: Required sheet is not appears directly in button click

swuehl — Wed, 29 Feb 2012 20:22:16 GMT

The moment you change the show condition of the sheet you are on by setting the variable, the sheet gets invisible, another one gets visible.

But to make sure that the newly visible sheet gets activated, add another action, layout - activate sheet to your button actions.

Please see attached.

Stefan

Re: Required sheet is not appears directly in button click

Wed, 29 Feb 2012 20:58:58 GMT

Hi Swuehl,

Thanks for your reply.

I have seen your app.But there you are using action to activate that particular sheets in corresponding buttons.

Can't we achieve that without using the action to activate those sheets in button.

Regards

.....

Re: Required sheet is not appears directly in button click

swuehl — Wed, 29 Feb 2012 21:04:31 GMT

Another approach would involve reordering your tabs, move all tabs that you want tot hide / show to the left, then following the ones that you want to show all the time.

Re: Required sheet is not appears directly in button click

Wed, 29 Feb 2012 23:47:25 GMT

Swuehl,

Thnks once again showing interest in this.

I have seen your recent file like you chanhe the order of tabs.

If that one will bw the fist sheet in my app it will be good.

But that type of sheet is available in the middle of my total sheets.So, I can't go with your recent solution.

Still is there any possibility to do how exactly i want...?

Thanks.....

Required sheet is not appears directly in button click

swuehl — Thu, 01 Mar 2012 00:08:37 GMT

I don't know any other possibility. As you see, in your originally posted app, you just set the visibility of sheets using the variables. If you hide a sheet which is currently activated, I believe QV will just activate the tab to the left. It will not activate the sheet(s) you are now showing automatically. Show / Hide and activation of sheets are distinct.

Since you are hiding one tab / showing one tab at the same time, it looks like the tab is replaced, but the activation state is not copied to the new shown sheet.

Why can't you add an action to the buttons like suggested in my first answer? Is there anything else we need to know about your setting, another constraint?

Re: Required sheet is not appears directly in button click

Thu, 01 Mar 2012 00:28:29 GMT

ok Swuehl,

Is there any reason why it went for the first sheet only always.

see in the attached file.

Thanks...

Required sheet is not appears directly in button click

swuehl — Thu, 01 Mar 2012 00:39:10 GMT

Well, probably my last statement that 'QV will just activate the tab to the left.'

was not fully correct, it seems to activate just the first tab to the left.

But anyway, I would just explicitely activate the tab I need using an action.

Thus I think you already have a working solution, and you haven't answered why this is not possible for you, so I won't spend any more time on this.