Clear Other Fileds

[#1]

How do i use Clear Other Field Option. I have 20 fields out of which i have to clear all the fields other than two fields (Product and Market) on activation of a sheet. I am writing in Clear Other Fields: (Product & Market) but this is not working. How do i write that ??

[#2]

Hello,

What you can do instead is use a combination of the following actions:

1. Lock Field: Product

2. Lock Field: Market

3. Clear All

4. Unlock Field: Product

5. Unlock Field: Market

The action "Clear Other Field" seems to work on related fields as I've read in the following post (didn't test it to actually see how it works):

http://community.qlik.com/message/63857#63857

Hope this will prove helpful.