Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anindya_manna
Partner - Creator II
Partner - Creator II

How to create 2x2 matrix table in qlikview?

  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-2021-3031-4041-5051-6060+
M233343536373
F121212121212
Company Owned114477110143176

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);

14 Replies
oknotsen
Master III
Master III

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 .

May you live in interesting times!
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Select the column and use principle drag and drop.

tamilarasu
Champion
Champion

Hi Anindya,

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

anindya_manna
Partner - Creator II
Partner - Creator II
Author

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
Master III
Master III

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 .

May you live in interesting times!