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: 
mikkeltaylor
Creator II
Creator II

Accumulate over 2 dimensions - Pivot works, chart incorrect

Hi all,

I'm trying to show the % of customers who buy a product when they buy their next product.  In my data I have First Product, Months until next product (SPD) and the number/% of customers.

I've read a lot of posts on using rangesum(above( and also Pareto techniques.  The pivot table below, works and shows the correct % for each product, but when I change to a chart it seems to accumulate the '%' for each product within the SPD so the lines all appear much closer than it should be.  any help much  appreciated!

Calculation that works in Pivot table:

RangeSum(Above(total( Sum([# of Individuals])/ sum(total <[First Product]>[# of Individuals])), 0, RowNo( TOTAL)))

Correct Pivot

pivot.JPG

Incorrect Chart

Chart.JPG

Thanks

Mike.

10 Replies
mikkeltaylor
Creator II
Creator II
Author

Have done, apologies. 🙂