Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

pankaj999
New Contributor

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
dilipranjith
Valued Contributor II

Re: Click through functionality on Charts

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
Valued Contributor II

Re: Click through functionality on Charts

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?

dilipranjith
Valued Contributor II

Re: Click through functionality on Charts

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)

Community Browser