Showing Amounts

[#1]

vHi,

In the attached graph, I have the average time per delivery, but next to the bar I want it to show the amount of deliveries that I have for that month so I can see the amount of deliveries and the average time taken.

Is this possible in QlikView? If so, how?

Thanks in advance.

[jonathandienst]

Well yes, it is possible, assuming that you have all the data necessary to load into your model. You would need details to calculate delivery time, date information to link into a calendar and delivery details.

If you want to add that to the graph, you could add some text in the bars, at the end of the bars or in the axis. Or use Qlikview's associations to create a second (or third) obect using the same dimensions, and each will track the selections made in the other objects.

[#3]

Hi Andrew,

you should be able to do this with a combo chart, create the first expression as the bar for the average and then the amount of deliveries as a symbol marker which you then show the data values for.

If you have an example you can upload, can help further

Hope that helps

Joe

[#4]

Unfortunately, I can't upload the example due to the type of company I'm working for. Do you have an example I can look at to see if I can see where it makes it possible? I already have the average (as we can see in the graph).

Cheers

Andrew

[#5]

Easier if you provide the real example, can then use your own expressions etc,

see this thread

Preparing examples for Upload - Reduction and Data Scrambling

on scrambling data for upload

Joe

[vvvvvvizard]

Add an expression

Count(Deliveries)

deselect bar and line checkbox

choose text as pop-up checkbox

ensure pop up labels r selected in the presentation tab

[Anonymous]

See if attached helps