topic Cumulative percentage chart issue in QlikView

Cumulative percentage chart issue

Fri, 12 Feb 2016 15:43:04 GMT

Hello All,

new day, new issue..

Today I'm trying to do a particular line chart with 2 dimension:

- DimensionA: Year

- DimensionB: vSellerRange = Floor(SellerAge,5)

Expression is just Count(Order).

Now, my goal is to have a chart where it's shown cumulative value for each SellerRange. So, basically, all curves will arrive to 100% with different time.

To do this, I'm using "extended progressive" option.

But I'm not able to understand what I have to do to have 100% for all lines.

In fact, if I use Relative option, only the best performance will reach 100%.

I'd like to do something like: Count(DISTINCT Order)/Count(Total<DimensionB>DISTINCT Order).

How I can put inside <> a variable?

Thanks in advance,

Salvo

Re: Cumulative percentage chart issue

sunny_talwar — Fri, 12 Feb 2016 17:54:20 GMT

Don't have the sample to test it, but can you try this:

RangeSum(Above(Count(DISTINCT Order)/Count(Total<DimensionB>DISTINCT Order), 0, RowNo()))

Re: Cumulative percentage chart issue

Gysbert_Wassenaar — Fri, 12 Feb 2016 17:56:56 GMT

You can't. The Total operator only works with real fields. You'll have to create DimensionB in the script as a field.