Click filtering on straight table expressions

Fri, 24 Jun 2016 19:17:09 GMT

Hello,

Currently I have a straight table with 3 dimensions that I want freezed paned. Lets assume these dimensions are

Deal, Name, Date

Now I have constants as expressions to add on. i.e (Banker,Underwriter,Risk...etc)

The straight table now looks like this :

Header 1	Header 2	Header 3	Header 4	Header 5	Header 6
Deal	Name	Date	Banker	Underwriter	Risk
Deal	Name	Date	Banker	Underwriter	Risk

Unfortunately when I click into a banker,underwriter.risk or etc... it will filter by the dimensions returning only one row item (the associated deal,name,date with that banker so the current selection in the current selection box is the value of that 1 deal,name,date). Ideally I'd like to see all rows related to the items I click that is an expression. So if I select the banker from the straight table I would like to see all deals associated with that banker. Is there a way in which I can click an expression and get all rows that contain that value using a straight table? It is ideal to have the ability to freeze pain.

topic Click filtering on straight table expressions in QlikView

Click filtering on straight table expressions