topic Re: line appears in chart, when set to continuous chart. in QlikView

line appears in chart, when set to continuous chart.

Thu, 27 Aug 2015 08:50:29 GMT

hi guys, 'simple' question. This straight line appears when I set my graph to continuous in the axes tab. Why is this, and what is this line? I have not found a way to turn it off.

I have one expression, I have not set any average line or horizontal reference lines.

expr:

Sum({<operator={'AAA'}>} aggr(Sum(total_hours/60*resource_quantity),ac_registr,TaskPerfDay,TaskPerfMonth))

Dimension: TaskPerfWeek

ideas?

Re: line appears in chart, when set to continuous chart.

crusader_ — Thu, 27 Aug 2015 09:01:07 GMT

Hi,

This line appears because of your data, especially dimension.

Your first (1) or last (52-53) week belongs to two months Dec and Jan.

Add year to make it different.

Hope this helps you.

Regards,

Andrei

Re: line appears in chart, when set to continuous chart.

Thu, 27 Aug 2015 09:01:53 GMT

Ye I think it has to do with that

Re: line appears in chart, when set to continuous chart.

Thu, 27 Aug 2015 13:27:30 GMT

Where would you suggest I add year. I tried it in the dimension and expresion. But its still like this. I know the problem now, but the solution has not worked yet.

Re: line appears in chart, when set to continuous chart.

crusader_ — Fri, 28 Aug 2015 06:42:45 GMT

Hi,

Hm... try to change your expression a bit:

Sum({<operator={'AAA'}>} aggr(Sum(total_hours/60*resource_quantity),ac_registr,TaskPerfDay))

Hope this helps you.

Regards,

Andrei

Re: line appears in chart, when set to continuous chart.

Fri, 28 Aug 2015 07:27:21 GMT

That does not seem to work either. The line only disappears when I change my dimension from TaskPerfWeek to something else.

Obviously because it has to do with the Week numbering. But how can I manipulate the dimension then? I still want the axis X to be in weeks.

Re: line appears in chart, when set to continuous chart.

crusader_ — Fri, 28 Aug 2015 07:33:28 GMT

Why do you use "Continious" checkbox?

PFA, perhaps it helps you to find solution.

Regards,

Andrei