Make an expression 'clickable'

[Anonymous]

I have created a chart/table with the first column containing a Dimension and a second columns containg an expression where I get the lowest transacionId for that Dimension.

I want to be able to click on the TransactionId that is displayed and get more details about it but it seems like it's the Dimension that is selected and not the expression.

The resulting table caontains e.g.

Col1(Dimension)     Col2(Expression)

CompanyName        1234

When I click on 1234 in Col2 does it look like Qliikwies has CompanyName as selected value and wont select just details about transaction 1234.

/Frank

[MK_QSL]

When you click on 1234, it actually not select 1234 but it is selecting CompanyName.

This is normal behaviour in Qlik.

You can create a table showing detailed transaction table and use conditional show from Layout tab.

If(GetSelectedCount(CompanyName) = 1,1,0)

[Anonymous]

I have tried what you suggested Manish but didn't get it to work, could you add an example ?

[marcus_sommer]

Try it with replacing the expression through a calculated dimension, for example:

aggr(Expression, CompanyName, transacionId)

- Marcus