topic Re: pivot table data in QlikView

pivot table data

Wed, 25 Nov 2020 16:16:04 GMT

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

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 — Thu, 23 Mar 2017 15:54:48 GMT

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 — Thu, 23 Mar 2017 16:16:41 GMT

Why not add two dimension

Dimension

Expression

Count(A) or Count(B)

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

Fri, 24 Mar 2017 10:28:28 GMT

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

oknotsen — Fri, 24 Mar 2017 12:55:50 GMT

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 .