topic Re: Help with axis in bar chart in QlikView

Help with axis in bar chart

hopkinsc — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a bar chart that i am using to compare reload times between 2 different days.

I have a dimension of reload name and 2 expressions.

the first expression is reload end time - start time to give the duration, this has set analysis within it to pick up the date from a variable.

the second expression is exactly the same but the set analysis is set to pick up the date from a different variable.

The expressions work, but the axis is doubled because of the 2 different dates.

what i want is the axis to just show a single time range the both bars appear against a single time, meaning they will show together.

Can anyone help?

I have attached an example

Re: Help with axis in bar chart

sunny_talwar — Fri, 09 Nov 2018 12:51:11 GMT

Look here

Files for creation of a Gantt chart

Re: Help with axis in bar chart

hopkinsc — Fri, 09 Nov 2018 12:59:33 GMT

Hi Sunny,

Thanks, I've looked at that and it seems straight forward. I think my issue is to do with the comparison bit where i am trying to compare exactly the same reload task but for different dates.

I have tried using TIME() in my expressions to ensure its ignoring the date part of the fields but it still seems to be doubling the axis values.