topic Re: Accumulation Line Chart can not stop to current month in QlikView

Accumulation Line Chart can not stop to current month

Sat, 15 Sep 2012 14:55:18 GMT

Hello Everyone,

I need create a line chart compare goal and actual. The goal goest to year end and actual is just to current month. After I finish this line chart, the actual line continue to year end. Can you help?

Thanks in advance,

Dust

Re: Accumulation Line Chart can not stop to current month

jonathandienst — Sat, 15 Sep 2012 15:00:02 GMT

I assume that you are using full acumulation on the chart. Rather than doing that, use an expression like

=RangeSum(Above(Sum(Sales), 0, RowNo()))

Depending on your data model, that should do the trick...

Hope that helps

Jonathan

Re: Accumulation Line Chart can not stop to current month

Sat, 15 Sep 2012 15:09:40 GMT

Thank you, Jonathan.

I tried RangeSum and full acumulation both methods. I get the same result. I load two crosstab table both Goal and Actual and joined with Company and Month.

The actual line should stop at current month. The one I have doesn't make any sense.

Thanks,

Dust

Re: Accumulation Line Chart can not stop to current month

jonathandienst — Sat, 15 Sep 2012 15:17:10 GMT

I suggest that you post your app - something in the model or expression is making it see zero values rather than missing values for the future months. Bear in mins that a sum() of nulls is 0, nor null.

Regards

Jonathan

Re: Accumulation Line Chart can not stop to current month

Sat, 15 Sep 2012 15:36:24 GMT

Hi Jonathan,

Thank you very much for your help. Please see attached test file. Your help is greatly appreciated.

Thanks,

Dust

Re: Accumulation Line Chart can not stop to current month

Sat, 15 Sep 2012 15:40:25 GMT

Thank you very much, Joanathan.

Please see attached testing file. It may give you more sense. Your help is greatly appreciated.

Dust

Re: Accumulation Line Chart can not stop to current month

swuehl — Sat, 15 Sep 2012 16:25:36 GMT

You can check on the current value and stop the line like

=if(sum ( {$<[Ops Month] = {"<=$(vOpsReviewMonth)"}>} [Revenue-Actual]),

rangesum(

sum ( {$<[Ops Month] = {"<=$(vOpsReviewMonth)"}>} [Revenue-Actual]),

above("Actual")

))

[you can also check on the current Month instead of the Value, if the Actual might be zero for some month]

You can also hide the line after a certain point using a appropriate background color.

See attached.

Hope this helps,

Stefan

Re: Accumulation Line Chart can not stop to current month

Sat, 15 Sep 2012 16:46:49 GMT

Stefan, Thank you very much. You answer is excetly what I need I pluge on my testing file it works perfectly. I still need add your code to my prod one.

Best regards,

Dust

Re: Accumulation Line Chart can not stop to current month

Sat, 15 Sep 2012 16:59:30 GMT

Stefan,

Can you write another code for month? based on your code, we need let chart show accumulation amoumt to the reviewmonth.

I appreciate your help.

Dust

Re: Accumulation Line Chart can not stop to current month

swuehl — Sat, 15 Sep 2012 18:35:01 GMT

Sorry, I don't just get what you want, can you tell me the measure using the fields in your sample that you want to accumulate?

Re: Accumulation Line Chart can not stop to current month

Sat, 15 Sep 2012 19:22:26 GMT

Stefan,

Your code works perfectly for me.

Thank you very much!!!

I appreciate,

Dust

Re: Accumulation Line Chart can not stop to current month

riceball — Fri, 08 Feb 2013 02:31:42 GMT

Hi Stefan!

I'm working on the accumulation line chart and I'm using your "Hiding line using background color" method to stop the line.

However, I realized that this method also hide my symbol for the current month as well. For example, if I choose Month=Apr, the symbol for the selected month Apr is also hidden.Though your second chart is my most ideal chart where it shows the symbols for selected month, I would prefer to use the hide line method

Is there any way I can show the symbol? Appreciated your help on this~