topic Click through functionality on Charts in QlikView

Click through functionality on Charts

pankaj999 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Click through functionality on Charts

dplr-rn — Wed, 10 Oct 2018 16:17:18 GMT

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?

Re: Click through functionality on Charts

sergio0592 — Wed, 10 Oct 2018 19:13:35 GMT

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.

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

Re: Click through functionality on Charts

dplr-rn — Wed, 10 Oct 2018 21:07:19 GMT

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)