topic Selection between sheets is not staying consistent in QlikView

Selection between sheets is not staying consistent

Fri, 11 Mar 2011 17:42:47 GMT

Hello,

I am using QlikView 9. I have a sheet in my application that I copied (list boxes and graphs) to another sheet. A list box on my first sheet is Month. When I select Jan, then switch to sheet 2, jan is not selected automatically as well. I would like for it to be selected also based on what the user selects from the first sheet. How do I make my selections consistent between the two sheets? I assumed since I copied sheet 1 and made sheet 2, it would automatically work.

Any help would be greatly appreciated!

Thanks,

nmellick

Selection between sheets is not staying consistent

Fri, 11 Mar 2011 18:03:03 GMT

Hello,

But thats the normal functionality of QV and you dont have to do anything differently as far as I know. If you copy a sheet and paste, then you have have the same selections on either of the sheets. Can you try creating a new file and then test it? Just close everything and try as this is strange. Please let us know what went wrong.

ANDY

Selection between sheets is not staying consistent

Fri, 11 Mar 2011 18:04:00 GMT

Hello Also check if there are any triggers on the sheet. Right click on sheet ->Properties -> and check if there are any triggers on Activate Sheet.

Selection between sheets is not staying consistent

Fri, 11 Mar 2011 18:12:35 GMT

I checked the first sheet that I was copying, and there is one trigger named Apply Bookmark and here's the code for it:

=if('$(vRequiresAttention)' = 'View Requires Attention', 'BM65', 'BM64')

This is for the OnActivate Sheet. There is nothing for OnLeaveSheet

Selection between sheets is not staying consistent

Fri, 11 Mar 2011 18:38:36 GMT

I did a quick test on a new file and it works fine as expected. The original is a template that I've been using that was created for us by QlikView consultants. There must be something wrong with the template. I'll have to re-create the entire app, but at least you helped me find the problem. Thanks for all your help!

nmellick

Selection between sheets is not staying consistent

Anonymous — Fri, 11 Mar 2011 18:40:42 GMT

But if the new sheet is a copy, most likely you have this trigger on activating this new sheet as well.