Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Create Pivot
Dim as A
Expressions are
1) Count({<B = {'X'}>}A)
2) Count({<B = {'Y'}>}A)
And give labels as X and Y
Create Pivot
Dim as A
Expressions are
1) Count({<B = {'X'}>}A)
2) Count({<B = {'Y'}>}A)
And give labels as X and Y
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
this solution worked...thanks a lot Anil, you are a life saver
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 .