topic Re: Retrieve data details from bar chart in QlikView

Retrieve data details from bar chart

cmano — Thu, 01 Sep 2022 08:09:44 GMT

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.

Re: Retrieve data details from bar chart

BrunPierre — Thu, 01 Sep 2022 08:41:36 GMT

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

Re: Retrieve data details from bar chart

cmano — Thu, 01 Sep 2022 10:03:05 GMT

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

Re: Retrieve data details from bar chart

BrunPierre — Thu, 01 Sep 2022 10:33:56 GMT

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

Re: Retrieve data details from bar chart

cmano — Thu, 01 Sep 2022 14:10:40 GMT

Excel Table?

Re: Retrieve data details from bar chart

BrunPierre — Thu, 01 Sep 2022 14:40:07 GMT

Certainly

Re: Retrieve data details from bar chart

deepanshuSh — Thu, 01 Sep 2022 17:55:47 GMT

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.

Re: Retrieve data details from bar chart

rwunderlich — Fri, 02 Sep 2022 02:36:43 GMT

Is this Qlik Sense or QlikView?

-Rob

Re: Retrieve data details from bar chart

cmano — Fri, 02 Sep 2022 05:21:32 GMT

Hello Rob is Qlikview

Re: Retrieve data details from bar chart

cmano — Fri, 02 Sep 2022 05:31:28 GMT

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

Re: Retrieve data details from bar chart

cmano — Fri, 02 Sep 2022 05:48:26 GMT

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

Re: Retrieve data details from bar chart

deepanshuSh — Fri, 02 Sep 2022 06:30:50 GMT

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.

Re: Retrieve data details from bar chart

cmano — Fri, 02 Sep 2022 06:36:24 GMT

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

Re: Retrieve data details from bar chart

BrunPierre — Fri, 02 Sep 2022 07:22:06 GMT

@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.

Re: Retrieve data details from bar chart

rwunderlich — Fri, 02 Sep 2022 14:22:57 GMT

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