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

[#1]

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!

[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?

[#3]

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]

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.

[chrismarlow]

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

Parent	Child
A	B
A	C
B	D
B	E
C	F

Which becomes;

L1	L2	L3
A	B	D
A	B	E
A	C	F

Or have I missed the point?

[#7]

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]

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

[#9]

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.