How to create 2x2 matrix table in qlikview?

[anindya_manna]

  Hi,

I want to create a table structure like below with Age group and Gender where each data cell will display no of customer per age group and gender.

	0-20	21-30	31-40	41-50	51-60	60+
M	23	33	43	53	63	73
F	12	12	12	12	12	12
Company Owned	11	44	77	110	143	176

This is my Customer table load script

[Customer]:

LOAD [Customer id],

     [Existing Customer],

     [Insertion Date],

     AGE,

     Gender,

     [Policy No]

FROM

(ooxml, embedded labels, table is Customer);

[oknotsen]

Make sure it is a Pivot Table.

Click on "Age" and keep your mouse button pressed.

Move your mouse to the top-right corner. An arrow will show up.

You might have to make some small circles with your mouse before the arrow points in the right direction (to the left instead of down).

Let go of your mouse and, tada, columns .

[MindaugasBacius]

Select the column and use principle drag and drop.

[tamilarasu]

Hi Anindya,

        You can follow the steps mentioned by Onno. Kindly let us know, if you have any issues.

[anindya_manna]

Hello,

Thank you very much for your reply.Finally I am able to do it.Actually I have unchecked allow pivoting option in presentation tab of pivot table.

this vedio is also good

QlikView | Pivot Tables - YouTube

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

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