I am fairly new to Qlikview but have been picking it up quickly as it’s a very flexible tool. However, I’ve got a request to take a straight table of metrics, and when a user clicks on that metric it takes them to a different page showing them a different child metric to the parent metric in different graphics and visualizations. My original thought was to somehow pass parameters to a dynamic sheet that will building a sheet based on the users selection passed from the metric page. Is there another way of going about this or am I going down the right path? Also, is there an “on click” function on the straight table to send a few parameters to the dynamic sheet?
There is no function associated with clicking on a table (or any object) caption. Clicking on a table cell makes selections, depending on a cell. If the cell is a dimension, clicking on it selects a value in this dimension. If the cell is an expression, you select one value in each dimension of the table corresponding to this cell.
So, you can have a conditionally hidden sheets (or charts on the same sheet), and conditions could be based on selections. You click on a cell, hence making selections - conditions change - and you show a different sheet (or hide current objects on the same sheet and show different objects).
No there is no OnClick function, but if you click one a cell in a straight table you will make a selection. Selections are document wide, not per sheet unless you specifically define alternate states and assign those to sheets. So a user selection is applied to every sheet, chart, listbox etc unless specifically overridden.
There is an OnAnySelect document trigger to which you can add actions, for example an Activate Sheet actions. That trigger will fire any time a selection is made. Note, if you click on a value in an expression column you don't select the expression value, but the dimension values on the same row.
There is no direct trigger on metric but we can achieve by creating e a trigger on dimension field from document properties (Good to have trigger on Dimention having lowest level of data ). and give condtion like if(getselectedcount(Dimention1)=1 and getselectedcount(Dimention2)=1 ,value). something like this.
