topic Line chart values hidden by other lines in QlikView

Line chart values hidden by other lines

Thu, 14 Jan 2016 07:47:52 GMT

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

Re: Line chart values hidden by other lines

Thu, 14 Jan 2016 08:06:02 GMT

Hi ,

Can you upload any sample app ?

Re: Line chart values hidden by other lines

udaya_kumar — Thu, 14 Jan 2016 09:27:47 GMT

Hi Andret,

Are these values same for both original and current?

Re: Line chart values hidden by other lines

Thu, 14 Jan 2016 10:34:52 GMT

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

Re: Line chart values hidden by other lines

dinuwanbr — Thu, 14 Jan 2016 10:38:27 GMT

Hi,

what about the increasing transparency in trend lines.

see the sample

BR,

Dinu1

Re: Line chart values hidden by other lines

Thu, 14 Jan 2016 10:49:36 GMT

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.

Re: Line chart values hidden by other lines

dinuwanbr — Thu, 14 Jan 2016 11:09:35 GMT

Hi,

PFA

BR,

Dinu1

Re: Line chart values hidden by other lines

Thu, 14 Jan 2016 11:22:31 GMT

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,

Re: Line chart values hidden by other lines

dinuwanbr — Thu, 14 Jan 2016 11:28:41 GMT

Hi,

See the attach. Use static min and max.

Br,

dinu1

Re: Line chart values hidden by other lines

awhitfield — Thu, 14 Jan 2016 11:43:56 GMT

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

Andy

Re: Line chart values hidden by other lines

Thu, 14 Jan 2016 11:53:06 GMT

Unfortunately no, these are trendlines they want to see was hoping there was a way to spread out the values on the y-axis.

Re: Line chart values hidden by other lines

awhitfield — Thu, 14 Jan 2016 14:37:33 GMT

OK try this:

1. on presentation tab set the Line width to 4

2. on expression tab, select sum(finance) and set the Line Style to '<S3>'

3. on expression tab, select sum(Target) and set the Line Style to '<W0.5>'

and you can see both lines quite clearly

Andy

Re: Line chart values hidden by other lines

Thu, 14 Jan 2016 15:12:13 GMT

a completely different approach you can take, especially since so many of the numbers overlap, is to plot 1 line that is just the difference, and when you hover, you can show values for original, current and the difference

you can also go to the mumbers tab and put in symbols for thousands and millions

Re: Line chart values hidden by other lines

rwunderlich — Thu, 14 Jan 2016 16:06:01 GMT

You can set static min & max based on the low/high values in the data.

RangeMin(

Min(aggr(sum(Finance), Year))

,Min(aggr(sum(Target), Year))

)

See attached.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Line chart values hidden by other lines

Fri, 15 Jan 2016 12:10:39 GMT

Hi Rob

I did what you suggested, most of the other guys have been helpful but yours so far is closest to what I am looking for. I attached and example of real figures on my model just to show what it does, Year 1314 everything is too close still, year 1415 and 1516 is what I am looking for but the lines are outside the range of the Line chart.

Did I miss something you did on your example?

Also I would like an alternative to having divide by 1000000 in the expressions. If I take it out there the Static Min and Static max also needs a change, but this is not the big issue right now. For now I can live with it and change it later

Re: Line chart values hidden by other lines

Fri, 15 Jan 2016 12:14:20 GMT

See the reply to Rob about using the divide by million. Something is not working 100% with the divide by 1000000, I have used your suggestion before in some other models, just here with the ranges on the line chart it does not work for me. Not sure again if I just have something small I am missing

Re: Line chart values hidden by other lines

rwunderlich — Fri, 15 Jan 2016 21:48:32 GMT

Here's your sample modified to fix the 1314 year. The selection in MonthName needed to be ignored in the Max()/Min() as well as the Sum(). See the attached.

Also, as an alternative to dividing by million, I just used the auto scaling on the Number tab.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Line chart values hidden by other lines

Mon, 18 Jan 2016 06:07:15 GMT

Thanks Rob, where is the autoscaling on the Number tab? Is it just using the $, $K, $M symbols

Re: Line chart values hidden by other lines

Mon, 18 Jan 2016 06:37:51 GMT

Got it, understand what you are doing. Two questions still though. What does Statis Step 1 do exactly?

Then is there a way of getting the values on the points to show within the value range , example having 138995 and 138965 also showing as values?

Re: Line chart values hidden by other lines

Mon, 18 Jan 2016 08:54:15 GMT

I added few fields we are also using to the RangeMin and RangeMax and now it's not working. I have had a look through the manuals but I am not understanding what is wrong. I think I do not understand what I should have between "Min" and "aggr(Sum" example why are you including the Monthname exclusion there, should I be adding all my fields as well?

RangeMin( Min({<MonthName=,AccountType = {P},BudgetTypeGroup = {Expenditure}>}aggr(Sum({<MonthName=,AccountType = {P},BudgetTypeGroup = {Expenditure}>}BudgetDistributionCalculation), FinancialYear, MonthName))

,Min({<MonthName=,AccountType = {P},BudgetTypeGroup = {Expenditure}>}aggr(Sum({<MonthName=,AccountType = {P},BudgetTypeGroup = {Expenditure}>}BudgetDistributionCalculation + BudgetMovementMonthly), FinancialYear, MonthName))

)