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.

[BrunPierre]

If you can elaborate on your requirement, retrieve data from where?

[cmano]

Of course

From the attached photo for example, as you look the first bar from the left  64-Εκδορές....(12.000 kg) i want to know the details of this result.

By details i mean the order/orders that cause this total sum.

The scope is to create a table where they will be able to see :

Order

Status.

Can i help you more?

Thank you

Customer

Destination and etc

[BrunPierre]

At this point, a sample of the data will be helpful.

[cmano]

Excel Table?

[BrunPierre]

Certainly

[deepanshuSh]

If you just want the user to view the fields or measures associated with the bar of the bar chart you can simply turn on view details section from the table general properties. However, 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. 

[rwunderlich]

Is this Qlik Sense or QlikView?

-Rob

[cmano]

Hello Rob is Qlikview

[cmano]

Hello Peter.

I remove the data for obvious reason.

The cells (AO1, BA1,BK1) with yellow colour are used in expression to create the bar chart.

So i want to make a table eg below 

 

where they can see from the bars the cells ( B1,C1, J1 , M1, CE1, AO1, BA1,BK1 ) with green colour

Thank you