Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to add New Customize Total in Qlik Sense Pivot Table.
as below
temp:
load * inline [
Student,Subject,Score
A,English,75
A,Maths,55
B,English,80
B,Maths,70
];
load * inline [
Dim,so_Dim
Student,1
Total,2
AverageTotal,3
];
exit Script;
Row Dimension
=Subject
Column Dimension
=pick(so_Dim,Student,Dim,Dim)
Measure
=pick(so_Dim,Sum(Score),Sum(Score),avg(Score))
can you please clarify what exactly are you trying to achieve ?
do you want to add another total column or just manipulate values in the existing total column??
Here is a reference, the underlying concept is the same
Partial Sums in straight table | Custom Labels in ... - Qlik Community - 1494646
if, you need more assistance; please post some sample data and mockup of expected output?
Hi,
I have added the required output screenshot for your reference and sample qlik output.
as below
temp:
load * inline [
Student,Subject,Score
A,English,75
A,Maths,55
B,English,80
B,Maths,70
];
load * inline [
Dim,so_Dim
Student,1
Total,2
AverageTotal,3
];
exit Script;
Row Dimension
=Subject
Column Dimension
=pick(so_Dim,Student,Dim,Dim)
Measure
=pick(so_Dim,Sum(Score),Sum(Score),avg(Score))
Hi,
Thanks...👍
I tried with the proposed solution and it worked fine however there are many rows which are required to be total on single table the row to be approx. 68+, it gives me performance issue and Qlik services goes down.
If any load tolerance level available to address this issue .
Another option is to have one to many association to the dimension value, if you can upload a sample app that best represents ur scenario; members here can take a look