Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cumulative percentage chart issue

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

2 Replies
sunny_talwar

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()))

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand