Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Action: Activate Sheet with Variable as SheetID

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

1 Solution

Accepted Solutions
christophebrault
Specialist
Specialist

I update my qvw.

My variable get value by getfieldselection()

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin

View solution in original post

4 Replies
christophebrault
Specialist
Specialist

Hi,

see this file, it works for me.

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
Anonymous
Not applicable
Author

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)

christophebrault
Specialist
Specialist

I update my qvw.

My variable get value by getfieldselection()

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
Anonymous
Not applicable
Author

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