topic Re: 2 axes presented on chart in QlikView

2 axes presented on chart

amber2000 — Thu, 25 Sep 2014 15:17:49 GMT

Hi everyone,

Again I'm calling out for help on creating a chart using 2 axes.

I want to see how many pallets I've received per aisle and per End_Time, to see at what time/Aisle_Desc I received the most pallets.

Time has many different values so I would like to group them in smaller parts.

In the attached QVW file you can see what I've allready tried and that the line for time is tiny dot instead of a line.

How can I do this in a representable way and what am I doing wrong?

Monique

rubenmarin — Thu, 25 Sep 2014 15:23:58 GMT

Hi Amber, EndTime is not an expression unles you want to get an average or a median, someting that will calculate over all times fro each aisle.

Check attachment to see other approach to show how time is divided in each aisle.

amber2000 — Thu, 25 Sep 2014 15:33:49 GMT

Hello Ruben,

That's not what I'm looking for, It's to much colors for one bar and difficult to read for end users.

Thank you for your help but I want something different