Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
pankaj999
Contributor III
Contributor III

Click through functionality on Charts

community.JPG

Hi , 

Is there any way to show the records underlying in a stacked bar chart when a user clicks on it ?

As shown in the image , if a user clicks on the blue area of a single bar then he gets to see the records in details , like open records in a table or maybe redirect to another sheet where the view is available.


Thanks

3 Replies
dplr-rn
Partner - Master III
Partner - Master III

I dont believe its possible the way you mentioned i.e. from bar chart to a table. only one out of the box is drill down

Did you check qlik branch for extensions?

sergio0592
Specialist III
Specialist III

Hi,

I think you can with Concat() function used as expression and check "Text as pop up option".

See the attached qvw file. On mouse over you can see thye order_id detail for a product and a country.

P5.jpg

Is it what you'are tryig to achieve or no?

dplr-rn
Partner - Master III
Partner - Master III

One possible work around is below approach

In your bar chart

add columns as expressions you need for a straight table and mark it as invisible (unfortunately all dimensions will have to be here)

Use fast change chart as a straight table and bar chart

When you change to a straight table the columns will appear

See attached (forgive the crappy data)