topic Re: Set Clear state . Seperately for each tab in QlikView

Set Clear state . Seperately for each tab

supriyabiware — Tue, 16 Jan 2018 15:01:27 GMT

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

Re: Set Clear state . Seperately for each tab

swuehl — Tue, 16 Jan 2018 16:00:56 GMT

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

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

Re: Set Clear state . Seperately for each tab

supriyabiware — Wed, 17 Jan 2018 08:54:58 GMT

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

Re: Set Clear state . Seperately for each tab

pablolabbe — Wed, 17 Jan 2018 10:06:57 GMT

Avoid using macros, you can just use Actions .

Re: Set Clear state . Seperately for each tab

supriyabiware — Fri, 19 Jan 2018 09:43:03 GMT

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

Re: Set Clear state . Seperately for each tab

swuehl — Fri, 19 Jan 2018 10:57:54 GMT

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.

Re: Set Clear state . Seperately for each tab

supriyabiware — Fri, 19 Jan 2018 11:43:40 GMT

Wow! this works perfectly perfect! thanks