topic Make an expression 'clickable' in QlikView

Make an expression 'clickable'

Anonymous — Fri, 09 Mar 2018 11:02:01 GMT

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

Re: Make an expression 'clickable'

MK_QSL — Fri, 09 Mar 2018 11:07:20 GMT

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)

Re: Make an expression 'clickable'

Anonymous — Fri, 09 Mar 2018 12:47:23 GMT

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

Re: Make an expression 'clickable'

marcus_sommer — Fri, 09 Mar 2018 13:05:51 GMT

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

aggr(Expression, CompanyName, transacionId)

- Marcus