Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
biob_stein
Contributor

Help creating matrix with Pivot/table

Dear Community,

i need help to achieve following table (vertical:A,horizontalSmiley Frustrated,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!

Tags (3)
1 Solution

Accepted Solutions
sorrakis01
Valued Contributor

Re: Help creating matrix with Pivot/table

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,

8 Replies
sorrakis01
Valued Contributor

Re: Help creating matrix with Pivot/table

Hi Paul,

Maybe like this.

Regards

awhitfield
Esteemed Contributor

Re: Help creating matrix with Pivot/table

Label for S is a space!

Andy

biob_stein
Contributor

Re: Help creating matrix with Pivot/table

Hi Jordi,

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

biob_stein
Contributor

Re: Help creating matrix with Pivot/table

First picture was wrong,

should look like this:

1.png

sorrakis01
Valued Contributor

Re: Help creating matrix with Pivot/table

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,

Re: Help creating matrix with Pivot/table

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
Contributor

Re: Help creating matrix with Pivot/table

Great Jordi,

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

Thanks for help!

sorrakis01
Valued Contributor

Re: Help creating matrix with Pivot/table

Welcome

Regards,

Community Browser