Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am working with pivot table and want to set values NULL in dependents of the total of the columns. The dimensions of my table are the color and size of products. In my approach I try to
The formula in the pivot table is
sum(Sales)/RangeSum(First(Sum(Sales), 1, NoOfColumns()))
and I calculate the total as
sum(aggr(sum(Sales), Sizes))/sum(total Sales)
However I end up with the following
The marked is a pivot table to demonstrate my problem and contains my custom calculated total values. The bottom table I my actual pivot table with totals in bold text. As one can see I calculate the totals correctly but they are somehow randomly distributed in terms of row location.
Depending on the column I want the same value for each cell. For example, the correct values for 32/32 in the orange table are 0.03, 0.03 and not 0.00, 0.03.
I there a method to provid the totals to each cell? Is there a smater way to set columns to Null if the total is <=0.01?
I updated the formula for the pivot table, because I forgot that I use RangeSum(First(Sum(Sales),1,NoOfColumns())) in the dominator and not just sum(total Sales).
it's not helping monday ,but it doesn't matter 🙂
let me help you.
to get the same calculation is each cell you easily take the formular:
sum(total <GROESSE_CLEANED> ABSATZ_STK)/sum(total ABSATZ_STK)
Hope it helps,