Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Fixed value while Sheet Selection

Hi

Is there any way where I can define value for field for particular Sheet and would stay last. Even if you clear it won't change.

Let say if I have 3 Sheets '2009', '2010' and '2011'.

I want to populate data for specific year without defining in Set analysis and not Resetable.

Thanks

5 Replies
MarcoARaymundo
Creator III
Creator III

Hi!

Any example?

marcus_sommer

Maybe you used SheetActivate-Trigger which set the value from field year to a certain value and then locked this field and by SheetDeactivate you unlocked and deselect again.

- Marcus

Clever_Anjos
Employee
Employee

Use the feature "Set Clear State"

1) Put your sheet in an Alternate State

2) Make your default selections

3) Click on "Set Clear State"

Capturar.PNG

Anonymous
Not applicable
Author

It's right answer. Thanks Clever for your suggestion.

Thanks Marcus.

Anonymous
Not applicable
Author

Thanks Marcus for your valuable time