topic Re: Combo Chart with accumulation and % change in QlikView

Combo Chart with accumulation and % change

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I'm having issues getting my combo chart to display correctly. I have attached a sample.

Essentially, I would like a line chart of % change from previous month (formula seems to be accurate in sample attached) .

A rolling 6 month. So take the latest 6 months.

Something like below but my accumulation seems backwards or my values are. I've been messing with the sort order but I cannot get to display corretly.

I would like to see

horizontal axis last 6 values. So starting with 201602 to 201603 to 201607. Also, I would need to reverse my line chart % change to read from lef to right and my accumulation to read correctly. It's wrong now. Values should be higher the later the month.

Re: Combo Chart with accumulation and % change

Mon, 18 Jul 2016 22:36:59 GMT

folow

Re: Combo Chart with accumulation and % change

Anonymous — Mon, 18 Jul 2016 23:14:46 GMT

Any ideas?

Re: Combo Chart with accumulation and % change

Anonymous — Mon, 18 Jul 2016 23:15:33 GMT

I'll check it out tomorrow, thanks,

Re: Combo Chart with accumulation and % change

sunny_talwar — Mon, 18 Jul 2016 23:49:37 GMT

Is this what you want?

Expressions used:

1) =RangeSum(Below(Count({<STARTDATE_YYYYMM = {"*2016*"}>} ID), 0, NoOfRows() - RowNo() + 1)) - > Without full accumulation

2) Num(

RangeSum(Below(Count({<STARTDATE_YYYYMM = {"*2016*"}>} ID), 0, NoOfRows() - RowNo() + 1))/

RangeSum(Below(Count({<STARTDATE_YYYYMM = {"*2016*"}>} ID), 1, NoOfRows() - RowNo() + 1)) - 1,

'#.00%')

Re: Combo Chart with accumulation and % change

Anonymous — Tue, 19 Jul 2016 12:40:32 GMT

Close. How would I update to Count all.

In the above example it takes the Count from what's displayed in the chart. I would like to count all but only display 6 values.

Re: Combo Chart with accumulation and % change

sunny_talwar — Tue, 19 Jul 2016 13:16:16 GMT

This?

Re: Combo Chart with accumulation and % change

Anonymous — Tue, 19 Jul 2016 13:44:08 GMT

No, I would like to see what's atttached but only display 6 months. When the dimension limit is selected the totals change. Can there be an expression that counts all and not based on what's being displayed? I hope that makes sense.

Re: Combo Chart with accumulation and % change

sunny_talwar — Tue, 19 Jul 2016 14:02:43 GMT

I am not sure what you are trying to do. Do you just want 6 month accumulation or all time accumulation? The image I posted above only shows 6 months without using the dimension limits. How is it not meeting your requirement?

Re: Combo Chart with accumulation and % change

Anonymous — Tue, 19 Jul 2016 14:15:01 GMT

all time accumulation but only want to display 6 months.

Re: Combo Chart with accumulation and % change

Anonymous — Tue, 19 Jul 2016 14:17:04 GMT

201607 = 48,258 is correct. I want to only see 6 months but all time accumulation.

Re: Combo Chart with accumulation and % change

sunny_talwar — Tue, 19 Jul 2016 14:50:08 GMT

Here you go.

Re: Combo Chart with accumulation and % change

Anonymous — Tue, 19 Jul 2016 15:06:53 GMT

I appreciate the help