pivot table data

[#1]

Dear experts, i have my source excel data in below format;

A       B

a_1    X

a_1    Y

a_1    X

a_2    Y

a_2    Y

b_1    X

b_1    Y

b_2    X

b_2    Y

But i need to achieve the below table using a Qlikview pivot table

A       X     Y

a_1    2      1

a_2    0      2

b_1    1      1

b_2    1      1

how can i achieve this?

[Anil_Babu_Samineni · Accepted solution]

Create Pivot

Dim as A

Expressions are

1) Count({<B = {'X'}>}A)

2) Count({<B = {'Y'}>}A)

And give labels as X and Y

[sunny_talwar]

Why not add  two dimension

Dimension

A

B

Expression

Count(A) or Count(B)

Make sure to pivot Column B, by dragging the dimension to the top

[#4]

this solution worked...thanks a lot Anil, you are a life saver

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .