Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Line chart values hidden by other lines

Hi

I have a line chart graph where the lines run on top of other lines as the values are so close. We need a way to  have the lines not overlap as much so you can see each line. This varies a lot between client as some may have values on the line chart running within 100000 of each other, in other case this may be in the millions.

I have tried different line styles and colors already, so this does not seem to be the solution. I have also taken out the forced 0 out  As seen in the example this is that I cannot separate the lines. Probably something with the scaling would work. Note though that for some values may sun in millions in other cases it could be in thousands

Tags (1)
27 Replies
Not applicable

Re: Line chart values hidden by other lines

Hi ,

Can you upload any sample app ?

udaya_kumar
Not applicable

Re: Line chart values hidden by other lines

Hi Andret,

Are these values same for both original and current?

Not applicable

Re: Line chart values hidden by other  lines

Some of them yes but other differ by 150000, the example is in millions, so sometimes the value does look identical for example 100,000,00.00 and the other line maybe 100,120,000.00

I just need a way for them both to be seen

dinuwanbr
Not applicable

Re: Line chart values hidden by other lines

Hi,

what about the increasing transparency in trend lines.

see the sample

BR,

Dinu1

Not applicable

Re: Line chart values hidden by other lines

Where exactly so you so it, somehow I am missing the setting on your example.Please let me know exactly where this setting is.

I think it's a helpful solution, though what I am looking for is a way to  "zoom in" when values are so close. Not a zoom in as such, but to have the scale smaller so you can view both lines.

dinuwanbr
Not applicable

Re: Line chart values hidden by other lines

Hi,

PFA

BR,

Dinu1

Not applicable

Re: Line chart values hidden by other lines

That is ok, but it does not solve the issue really, as I said in the original my exampesa are in the millions

See the attached example, I just changed the values, this is where my issue is. For one client we are talking millions, other clients maybe in 100 of thousands. If I can get to a solution on the figures in my latest example it would be good, Note it has to be easy enough to see,

dinuwanbr
Not applicable

Re: Line chart values hidden by other lines

Hi,

See the attach. Use static min and max.

Br,

dinu1

awhitfield
Not applicable

Re: Line chart values hidden by other lines

Could you not have one expression as a line and the other as a symbol?

Andy