We have a bar char that shows data by month level. One bar for each month. The user would like to see the excel detailed data on clicking each bar. The excel should contain detailed data that constituted that bar. This is like a drill through report in other BI tools where in we can link other report to each bars in a bar chart. Can this be achieved in Qlikview? Drill/Cyclic groups is not an option here because details will come in the bar chart itself which is too much of data to show in a bar chart. We need to open an excel sheet with details.
well, I assume you could do what you're asking with something detecting a selection in your dimension field, and opening an Excel file in a macro. But I've never done that, don't really know how without looking a lot of things up, and I don't see the need anyway - QlikView is perfectly capable of displaying details.
If there's room on the tab, I'll often add a details section beneath the other chart(s). It's just a straight table with the fields of interest. If there's not room, or if I may want to go to the details from a lot of different starting points, I'll add a details tab.
Thanks for your response. I agree with your ideas of showing details below the graph and having details tab. Having hyperlink on the bars within bar chart with link to details in excel is the best way to represent that data per user needs we have. I am not sure how the macro stuff works because we need to pass the filters from the bar that we selected. I was looking for default functionality in Qlikview that allows to link the details to bars which seems to be not possible. I am a fan of this tool but in general comparison this feature is very much possible with other tools like Cognos. Please let me know any thoughts or ideas.
