User-friendly way to have fields selected on one click

[#1]

All,

I would like to implement several 'automatic selection tools'.

Business need: for instance, marketing often needs to request the following

* product p1, last year, EMEA+APAC

* product p2, last two years, RUSSIA, EMEA, APAC

So, there is a need for two actions to be implemented.

Technical solution

1. in a first step, on QLikView client Personal Edition

2. in a second step, on QLikView server

I would like to know;

• how to implement in a script the automatic selection of different fields ?

• Then, what would be user-friendly way to present all possible actions, in your opinion ?

Would you have some example document with this ?

Best regards

[swuehl]

I think the way to go is looking into document bookmarks, which should serve your needs.

For selecting something like last year our last two years, use a search expression on your date fields instead of a static value search, so this will update automatically in the future.

edit: Maybe using a search string in your Date list box like

=Date>=addyears(today(),-1)

then creating the bookmark.