Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

amiumi66
New Contributor III

What to use pivot or straight and how for my example

Student#Student NameDate# Days Since last testSubjectTest ValueTest RecievedDifference
ATom1/1/201717Math302010
ATom1/5/201723English25205
ATom1/1/201744Science50446
BGale6/3/201756Math30228
BGale3/2/2017126Science30273
CErin3/2/2017233Math25205
CErin4/2/201777Science45405
CErin3/2/201796History35305

Require:

I need subtotal by Student# on Difference. Which should be sorted by # of Days Since Last test.

Question: How do you determine if you need Straight Table or Pivot.

Results: Subtotal By Student# & Grand total at the end + within each student data is sorted by #Days Since last test.

        

Student#Student NameDate# Days Since last testSubjectTest ValueTest RecievedDifference
ATom1/1/201744Science50446
ATom1/5/201723English25205
ATom1/1/201717Math302010
Subtotal 1058421
BGale3/2/2017126Science30273
BGale6/3/201756Math30228
Subtotal 604911
CErin3/2/2017233Math25205
CErin4/2/201777Science45405
Subtotal 706010
Grand Total 23519342
2 Replies
amiumi66
New Contributor III

Re: What to use pivot or straight and how for my example

I want subtotal to be only shown for Difference not for Test Value or Test Recieved. I want to omit those ones.

        

Student#Student NameDate# Days Since last testSubjectTest ValueTest RecievedDifference
ATom1/1/201744Science50446
ATom1/5/201723English25205
ATom1/1/201717Math302010
Subtotal 21
BGale3/2/2017126Science30273
BGale6/3/201756Math30228
Subtotal 11
CErin3/2/2017233Math25205
CErin4/2/201777Science45405
Subtotal 10
Grand Total 0042
atkinsow
Valued Contributor II

Re: What to use pivot or straight and how for my example

This is the closest I could get.  I hope it helps.

On the presentation tab, you'll need to make sure Partial Sum is checked.