Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
StudentName | Score | Age |
---|---|---|
A | 55 | 21 |
A | 43 | 19 |
A | 55 | 18 |
B | 55 | 27 |
B | 43 | 18 |
B | 44 | 17 |
B | 33 | 18 |
B | 43 | 25 |
How can i create a pivot with subtotal of score only if Age is less then 20. Sub total will ignore the score for Age higher then 20.
May be this?
LOAD StudentName,
Score,
Age
FROM
[https://community.qlik.com/message/1256839]
(html, codepage is 1252, embedded labels, table is @1);
Create Pivot Object and use Dim as StudentName
Expression is Sum({<Age = {'<20'}>}Score)
Go to Presentation tab and check the Partial Sum if you need