topic Re: Set Clear State & Lock fields in QlikView

Set Clear State & Lock fields

carolin01 — Tue, 25 Mar 2014 08:46:16 GMT

Hello,

In my application I´ve set a clear state that clears all fields except then one value in a list box. Now I was testing the application and noted that when I lock other fields and then press clear that even the locked fields are cleared. Is my set clear state the reason or are there other reason? Do you have examples how to solve this?

Best regards,

Carolin

Re: Set Clear State & Lock fields

Tue, 25 Mar 2014 08:53:15 GMT

Hi Carolin,

This is happening because of the Set Clear state only.

You can lock those fields first and then set it as a clear state. so when you click on clear those fields will automatically get locked.

Hope this helps!

Re: Set Clear State & Lock fields

carolin01 — Tue, 25 Mar 2014 09:02:11 GMT

Hi,

there is only one specific field that I want to keep and therefore I set the clear state. But now I still want my users to decide flexible if they lock fields by themselves for their own analysis. And this isn´t working anymore as the set clear state even clears locked fields that the user has locked before. For me this even looks like a bug in Qlik View, isn´t it? So I´m searching for examples what else I could do?

Best regards,

Carolin

Re: Set Clear State & Lock fields

Tue, 25 Mar 2014 09:05:52 GMT

If there is only one field where you want to keep the selection then instead of set clear state why not use "Always Onse Selected" ?

That way the field will have the selected value and the locked selections won't also disappear even by clicking on clear.

Re: Set Clear State & Lock fields

Tue, 25 Mar 2014 09:10:59 GMT

Hi.

Unfortunately QV build the "Set Clear State" like this.

You will have to either trigger other fields upon selecting "Clear" or include the lock fields as part of the "Clear State".

Also have a look at this article.

http://community.qlik.com/thread/27654

Thanks

Re: Set Clear State & Lock fields

sunilkumarqv — Tue, 25 Mar 2014 09:12:27 GMT

you can use set clear function after changing it to alternate state you can do it

Re: Set Clear State & Lock fields

carolin01 — Tue, 25 Mar 2014 09:12:42 GMT

Because that field also should have mutiple selections. The list box enables or activates expressions in a chart. Sometimes the user would like to see one, two or three expression in the chart but always at least the total sales. This is screenshot of my listbox.

I always want to keep total, but the user should also be able to see the plan, the year-to-date and outlook if he wants.

Re: Set Clear State & Lock fields

carolin01 — Tue, 25 Mar 2014 09:13:40 GMT

What means changing it to alternate state?

Re: Re: Set Clear State & Lock fields

Tue, 25 Mar 2014 10:27:56 GMT

If you want multiple selections also to happen then you can use "alternate states" option. (only if you are using V11 and above)

See this from reference manual:

Also, this is from reference manual:

"Pressing the Clear button affects all states. However, a menu item has been added to the Clear button dropdown"

Unfortunately, I don't have access to V11 right now, so could not create alternate states and help you.

Re: Set Clear State & Lock fields

carolin01 — Tue, 25 Mar 2014 11:27:47 GMT

OK, I guess that´s the answer. I don´t have V11 yet but will keep it in mind for the future. Thank you for your quick help!

Re: Set Clear State & Lock fields

sunilkumarqv — Tue, 25 Mar 2014 11:30:24 GMT

Shyamal Pandit put the words how alternate state works ,that what I'm trying to say anyway you got the solutions