Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
supriyabiware
Creator
Creator

Set Clear state . Seperately for each tab

Hello All,

I have a requirement of setting Clear state when Clear is clicked.

But i have 2 tabs -

Tab 1  - Entschieden - where Flag Status is locked to 'Entschieden'

Tab 2  - Offene           - where Flag status is locked to 'Offene'

when i use below macro it is setting lock dimensions same for both tabs.

sub SetClearState

        ActiveDocument.SetClearState

end sub

How can i solve this?

Note - i want to only save one filter from getting cleared here. and locked object to remain as they were

Thanks

Supriya

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Something like attached?

I've used a data island with OnChange trigger actions to emulate the clear state action. See comments in textbox and script.

View solution in original post

6 Replies
swuehl
MVP
MVP

I assume your setting contains more Actions / Macros than described.

Please add a small sample QVW to better understand your current work.

supriyabiware
Creator
Creator
Author

Hello Stefan,

Thankyou for the reply.

i am unable to upload the qvw since its very huge! i will try to build a sample version till then..

1. i have 2 tabs - Entschieden and offene

2. Entschieden tab has locked object - a flag which is set to 'Entschieden'

3. Offene Tab has locked object - a flag which is set to 'Offene'

4. when user uses Clear - i need to retain the locked objects as it is in each tab(like clear others except flag for that tab)

5. when user uses Clear - i need a clear state macro which will not touch the lock objects and one more object(Lieferant) will set to default as mentioned in macro.

Thanks

Supriya

pablolabbe
Luminary Alumni
Luminary Alumni

Avoid using macros, you can just use Actions .

supriyabiware
Creator
Creator
Author

Here is the sample example!

i have to set clear state Status(locked) and XXGroup! as it is on both tabs

Is this possible?

Thanks

Supriya

swuehl
MVP
MVP

Something like attached?

I've used a data island with OnChange trigger actions to emulate the clear state action. See comments in textbox and script.

supriyabiware
Creator
Creator
Author

Wow! this works perfectly perfect! thanks