Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
frankrudolf
Contributor III
Contributor III

Make an expression 'clickable'

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

3 Replies
MK_QSL
MVP
MVP

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)

frankrudolf
Contributor III
Contributor III
Author

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

marcus_sommer
MVP & Luminary
MVP & Luminary

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

aggr(Expression, CompanyName, transacionId)

- Marcus