topic Re: Pivot table help in QlikView

Pivot table help

Tue, 13 Aug 2013 17:19:55 GMT

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)

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

1 2

2 2

3 1

4 2

5 2

or something similar of that fashion...

Tue, 13 Aug 2013 17:24:24 GMT

Use Chart Type Pivot Table

Gysbert_Wassenaar — Tue, 13 Aug 2013 17:28:53 GMT

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

Tue, 13 Aug 2013 17:33:17 GMT

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

Nagaraju_KCS — Tue, 13 Aug 2013 17:33:41 GMT

go to the object properties,

Presentation tab=====>

select the Y diemention and check the Show Partial sums option

Click apply