Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to store/retrieve last clicked record on a straight table?

Hi,

I have a recursive data model (Parent-Child mode) that I need to store the whole selected (clicked) record using something like on-click trigger in order to use it for filtering the results.

Is that possible in QlikView anyway? I'm coming from Applications development background and such things are pretty easy and straight forward and not sure if that doable in QView!

Thanks!

9 Replies
Gysbert_Wassenaar

In Qlikview when you click on a dimension value the data in the document is filtered by that value. Does that answer your question?


talk is cheap, supply exceeds demand
Not applicable
Author

Unfortunately not, I'm aware of the dimension filtering but because of my data model I want the end user to click on the grid (the straight table) and consequently I'll need to store the current clicked record in order to use it later in the expressions.

Anonymous
Not applicable
Author

As Gysbert pointed out, clicking on a row in a straight table selects value in each dimension of this table.  You can create a variable (probably need an additional "button-click" to capture it) which contains these selections, and use it in a set analysis in your expressions.  You can even pre-format your variable as a set to make expressions look simple.

Gysbert_Wassenaar

In Qlikview Desktop and the ajax client there are back and forward buttons to step back and forward through the selections. You can also use button or text objects with Back of Forward actions to do the same. And there are Bookmarks. You can use button or text objects with Replace and Activate bookmarks to store and retrieve selections stored in a bookmark.


talk is cheap, supply exceeds demand
chrismarlow
Specialist II
Specialist II

Do you not need to flatten your hierarchy into a QV friendly form, so I am assuming you have something like;

ParentChild
AB
AC
BD
BE
CF


Which becomes;

L1L2L3
ABD
ABE
ACF

Or have I missed the point?

Not applicable
Author

How can I capture the "button-click" event and store the current selected record into a variable? Looking at the Straight Table Chart objects it doesn't have a trigger event! Could you please provide an example or a demo file?

Anonymous
Not applicable
Author

By adding a button which you have to click after making that selection.  Sorry, there is no event to trigger...

Not applicable
Author

Well, regardless of these buttons in QView, in a simple straight table chart, when you click on any record, is it possible to store the whole clicked -selected- record in any object or parameter in order to use the stored record later?

Gysbert_Wassenaar

You can add a Replace bookmark to the OnAnySelect document event trigger. You can find that trigger on the Triggers tab of the Document Properties window.

But I'm afraid you're thinking to much like an application developer with your focus on click events and triggers. Simply learn your users how selections work and how to use the back and forward buttons. And after that teach them how to create and use bookmarks.

Let the user control the interaction with the data. Don't try to hardcode that. It will restrict users unnecessarily and worse is likely to confuse them.


talk is cheap, supply exceeds demand