Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table help

Hey guys,

I need help making a pivot table.

My data looks something like

X     Y    Sum(values)

----------------------------

A     1             2

A     2             2

A     3             1

A     4             2

A     5             2

B     8             1

B     9             1

C     10            2

D     11            2

E     12            2

How do I get a pivot table where it would look something like

X    Sum(values)

A(+)     8

B(+)     2
C(+)     2
D(+)     2
E(+)     2

and if u press the + button on the A, it would show

X        Sum(values)

----------------------------

A  

    1             2

    2             2

    3             1

    4             2

    5             2

or something similar of that fashion...

1 Solution

Accepted Solutions
Gysbert_Wassenaar

I don't understand the problem. That sounds like the standard behaviour of a default pivot table. See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Not applicable
Author

Use Chart Type Pivot Table

Gysbert_Wassenaar

I don't understand the problem. That sounds like the standard behaviour of a default pivot table. See attached qvw.


talk is cheap, supply exceeds demand
Not applicable
Author

Yeah, it seems when I did partial sums, it worked. Thanks a lot!

qv_testing
Specialist II
Specialist II

go to the object properties,

Presentation tab=====>

select the Y diemention and check the Show Partial sums option

Click apply