Retrieve data details from bar chart

[cmano]

Dear all.

I have the below bar chart.

The expression i use to create the bar chart is sum (E1 + E2 +E3+E4).

 

So for the first bar  with code 64 and for the others i want to retrieve data like the orders, machines etc.. of the materials that caused this bar chart.

Any suggestion?

Thank you all.

[cmano]

Hellow  @deepanshuSh 

view details section from the table general properties : I can not find this section on general tab 

if you want to showcase all the fields and their respective detailed data to be visualized you can create a button and link that button to a table that you would need to create separately for the bar. You can use container for putting different charts together.  : How i am gonna achieve that?

Thank you

[deepanshuSh]

For the first thing, when you click on properties of the table under general properties, you can see the show/hide details button. 

For the creation of the required data as per your latest comment, you need to create two charts one table and other bar chart, one having the bar chart and other the required information, you can create multiple charts here as per the requirement and keep on adding here under the tabs of the container. Also, for better visualization you can use the grouped container extension. 

[cmano]

i believe that is qliksence right? i work at qlikview enviroment 

[BrunPierre]

@cmano I think you should explore the use of a fast chart type change for this scenario. Thus, visualizing data in different ways for different purposes. 

In the General tab of your chart properties, you need to check the other chart you want to convert, then you can simply toggle as below.

By clicking on the fast change icon, the chart will change to the indicated type.

Hope it helps.

 

[rwunderlich · Accepted solution]

See this downloadable example:

Qlikview Cookbook: Conditional Show of Details https://qlikviewcookbook.com/recipes/download-info/conditional-show-of-details/

Sheet "Bar Chart Select" shows how you can show detail chart(s) when clicking on a bar. 

Another option is to form the detail data you want as an additional expression in the bar chart and uncheck bar and check "text as popup" in the expression Display Options. That will show your details in a popup when you hover the bar. 

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com