Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

line appears in chart, when set to continuous chart.

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

line.dib

ideas?

1 Solution

Accepted Solutions
crusader_
Valued Contributor

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

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

6 Replies
crusader_
Valued Contributor

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

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

Not applicable

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

Ye I think it has to do with that

Not applicable

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

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.

crusader_
Valued Contributor

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

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

Not applicable

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

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.

crusader_
Valued Contributor

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

Why do you use "Continious" checkbox?

PFA, perhaps it helps you to find solution.

Regards,

Andrei

Community Browser