Click and produce the result

[smilingjohn]

Hi All, 

I have a pivot table everything is working perfectly . within the table I have column called indicator as shown in the screenshot below  , If I click on any of the traffic indicator then it should show me one row  but currently when I click it will show the whole table with that matching LED . How can I make this table to response on my click in show the one row for particular click . 

Before Click              

    After clicking on red indicator 

Need help on this 

Thanks 

[AndyC · Accepted solution]

This is expected behavior.

Qlik is not the same as excel so you cannot select a row, when you click on an element in a chart or table you are telling Qlik to apply a filter.

So, when you click on the red traffic light you are asking Qlik to filter by the colour of the Traffic Light NOT any other values in the row.

[West69]

---

@smilingjohn wrote: HISD Connect

Hi All, 

I have a pivot table everything is working perfectly . within the table I have column called indicator as shown in the screenshot below  , If I click on any of the traffic indicator then it should show me one row  but currently when I click it will show the whole table with that matching LED . How can I make this table to response on my click in show the one row for particular click . 

Before Click              

    After clicking on red indicator 

Need help on this 

Thanks 

---

Thanks a lot for the reply. I will try the suggested solution from your link.