Drill down by selecting expression values

[Sunil_Kenth]

Hi,

I have a straight table with just expressions within it.

I would like to select a value of an expression and then be able to drill down into the transactions that make up that value.

The normal QlikView behavior when clicking on an expression value is to select the associated dimension, for which i could then use event triggers to activate another object, however in my case i do not have any dimensions in my table.

Thanks,

Sunil

[swuehl · Accepted solution]

Maybe place transparent text boxes over your expression values and use selection actions to filter accordingly.

Though this would not be intuitive to users used to standard QV behaviour.

[sudeepkm]

if you are displaying Transaction IDs in a table and you want to click on one of the transaction id which would take you to the next sheet or activate another object which shows the details of that transaction then you can use Field event trigger on Transaction ID. You can create a separate view that will have details of the transaction or can set variable that can be used for conditional display of two tables Summary Transaction table and Detailed Transaction table.