Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
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. 🙂