topic Re: Help creating matrix with Pivot/table in QlikView

Help creating matrix with Pivot/table

Anonymous — Wed, 29 Jul 2015 08:00:03 GMT

Dear Community,

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

with following data:

A_S:

LOAD * INLINE [

A, S

1, 1

1, 2

1, 4

1, 5

2, 1

3, 2

4, 1

5, 1

];

Actually i only achieve this:

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!

Re: Help creating matrix with Pivot/table

sorrakis01 — Wed, 29 Jul 2015 08:11:18 GMT

Hi Paul,

Maybe like this.

Regards

Re: Help creating matrix with Pivot/table

awhitfield — Wed, 29 Jul 2015 08:19:12 GMT

Label for S is a space!

Andy

Re: Help creating matrix with Pivot/table

Anonymous — Wed, 29 Jul 2015 08:59:53 GMT

Hi Jordi,

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

Re: Help creating matrix with Pivot/table

Anonymous — Wed, 29 Jul 2015 09:02:42 GMT

First picture was wrong,

should look like this:

Re: Help creating matrix with Pivot/table

sorrakis01 — Wed, 29 Jul 2015 09:05:59 GMT

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:

In presentation Tab put Null Values to 0 or empty.

Regards,

Re: Help creating matrix with Pivot/table

Kushal_Chawda — Wed, 29 Jul 2015 09:07:08 GMT

try like this

A_S:

LOAD *,S as S1 INLINE [

A, S

1, 1

1, 2

1, 4

1, 5

2, 1

3, 2

4, 1

5, 1

];

Dimension:

drag the S1 horizontally

Expression: Count(S)

Please see the attached

Re: Help creating matrix with Pivot/table

Anonymous — Wed, 29 Jul 2015 09:20:27 GMT

Great Jordi,

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

Thanks for help!

Re: Help creating matrix with Pivot/table

sorrakis01 — Wed, 29 Jul 2015 09:21:28 GMT

Welcome

Regards,