Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
biob_stein
Creator
Creator

Help creating matrix with Pivot/table

Dear Community,

i need help to achieve following table (vertical:A,horizontal:S,Values: count of S appear) :

1.png

with following data:

A_S:

LOAD * INLINE [

    A, S

    1, 1

    1, 2

    1, 4

    1, 4

    1, 5

    2, 1

    3, 2

    3, 2

    4, 1

    5, 1

];

Actually i only achieve this:

2.png

Horizontal 1 ... 5 are Expressions like if(S=1,COUNT(S)) ... if(S=5,COUNT(S))

I dont want to display the S Dimension, and want the counted results of S for A, so only one row and not broke up over all S possibilities.

Please help!

1 Solution

Accepted Solutions
sorrakis01
Specialist
Specialist

Hi Pauls,

1-. Use Pivot Chart.

2-. Create 2 dimensions: A and S

3-. Label Dimejnsion S is a space

4-. Create one Expresion: Count(S)

result:

Captura1.PNG

In presentation Tab put Null Values to 0 or empty.

Captura2.PNG

Regards,

View solution in original post

8 Replies
sorrakis01
Specialist
Specialist

Hi Paul,

Maybe like this.

Regards

awhitfield
Partner
Partner

Label for S is a space!

Andy

biob_stein
Creator
Creator
Author

Hi Jordi,

could you please explain your solution as i can not open your file, thanks!

biob_stein
Creator
Creator
Author

First picture was wrong,

should look like this:

1.png

sorrakis01
Specialist
Specialist

Hi Pauls,

1-. Use Pivot Chart.

2-. Create 2 dimensions: A and S

3-. Label Dimejnsion S is a space

4-. Create one Expresion: Count(S)

result:

Captura1.PNG

In presentation Tab put Null Values to 0 or empty.

Captura2.PNG

Regards,

View solution in original post

Kushal_Chawda

try like this

A_S:

LOAD *,S as S1 INLINE [

    A, S

    1, 1

    1, 2

    1, 4

    1, 4

    1, 5

    2, 1

    3, 2

    3, 2

    4, 1

    5, 1

];

Dimension:

A,

S,

S1

drag the S1 horizontally

Expression: Count(S)

Please see the attached

biob_stein
Creator
Creator
Author

Great Jordi,

my problem was that I did not know how, that we can display a dimension also horizontal.

Thanks for help!

sorrakis01
Specialist
Specialist

Welcome

Regards,