Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Previous 10 selected values in QlikView

Hi Champs,

I have a Table box in which I show the list of companies and a user clicks on it to see the detail data. Now, I need to capture previous 10 selected Companies and show it up in a list box or any component so that he can re-use it. I never mind if it is restricted to a session or not. I don't want to go with bookmark feature. Is this feasible in QlikView?

Please help me on this.....

Thanks & Regards,

Praveen Palle

2 Replies
simondachstr
Specialist III
Specialist III

This is just an idea, and I haven't tried it yet.
In set analysis $1 represents the last selection, $2 the pre-last etc.

What you can do, is to create a dynamic dimension using ValueLoop() function which is integrated in the set identifier to address previous selections.

marcus_sommer

You will always need a permanent storage from the selections or the selections process will be restricted to the session. The easiest way will be to use bookmarks or you need some macros or extensions.

For this you could create a variable which contained the last ten selected values - will be filled per OnChange action on this field, perhaps with some checks, distinct or not distinct and so on. And another variable picked the desired selection per pick(match()) function. Within the set analysis expression you put something like that sum({< FIELD = {"S(var)"} >} VALUE). You will be need some time to build this ....

- Marcus