topic Re: Action: Activate Sheet with Variable as SheetID in QlikView

Action: Activate Sheet with Variable as SheetID

Anonymous — Tue, 29 Nov 2011 14:26:12 GMT

Hi QlikView-folks,

here is my problem:

I want a button, which activates a sheet dynamically. The SheetID is stored in a variable vField, it depends on a selection made in a specific field.

Now i tried to activate the sheet by the action "Activate Sheet" and instead of the SheetID i wrote the variable =vField. Unfortunatly this doesnt work and the sheet is not acitivated. Does anybody have an idea how to solve this?

Thank you.

Mila

Re: Action: Activate Sheet with Variable as SheetID

christophebrault — Tue, 29 Nov 2011 14:36:45 GMT

Hi,

see this file, it works for me.

Action: Activate Sheet with Variable as SheetID

Anonymous — Tue, 29 Nov 2011 14:42:14 GMT

Hi,

thanks for the fast response. I tried it exactly this way, but without success.

Does it matter how the SheetID is mapped to the Variable vField?

In this case the variable gets the Sheet ID via vField=GetFieldSelections(Field)

Re: Action: Activate Sheet with Variable as SheetID

christophebrault — Tue, 29 Nov 2011 14:52:24 GMT

I update my qvw.

My variable get value by getfieldselection()

Action: Activate Sheet with Variable as SheetID

Anonymous — Tue, 29 Nov 2011 14:59:17 GMT

Thank you. I found my mistake, i wrote the name of my variable wrong. Works now perfectly.