Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
Gartner® Magic Quadrant™: 15 YEARS A LEADER - GET THE REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Click and produce the result

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              

smilingjohn_0-1663827946369.png

    After clicking on red indicator 

smilingjohn_2-1663828190337.png

 

Need help on this 

 

Thanks 

 

 

 

Labels (3)
1 Solution

Accepted Solutions
AndyC
Contributor III
Contributor III

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.

 

View solution in original post

1 Reply
AndyC
Contributor III
Contributor III

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.