topic Re: Two dimensions in a crosstable in QlikView

Two dimensions in a crosstable

Tue, 26 Jun 2012 07:23:56 GMT

I don't know how to make one dimension appear crosstabulated with another. The numbers I am looking for is the aggregated numbers in percent. Also the coloring is a bit of an issue as it is ( se picture) though I have the RGB values

Translation:

Klasse = Class

Volum = Volume

Andel = Share

Tilgang = New

Avgang = Drop outs

Mislighold / Misl. = In breach

Uklassifisert = Unclassified

Ned = Down

Uforandret = Unchanged

Opp = Up

So the main issue is how to hook on the A / B/ C... because it is the values in another variable.

Re: Two dimensions in a crosstable

jaspal_icon — Tue, 26 Jun 2012 07:42:04 GMT

Hi there,

Explain your problem in detail, also attach some sample data or sample qvw file which can explain what the desired result you are looking for.

Regards

Jaspal

Re: Two dimensions in a crosstable

Tue, 26 Jun 2012 08:29:04 GMT

Hi there,

I have this data to work with, see included file.

So I want the data to appear like in the included picture in the first post.

Where Klasse = m3_Klasse and the (A, B, C, D, E, F, G, Misl., Ny) are the values that the variable Klasse might have. I want to try to crosstabulate those values with the dimension m3_Klasse

Update:

I have manged to load the data in as a crosstable, but I now wonder which chart type will give me the representation that I am seeking.

Klasse_A_sum Klasse_B_sum Klasse_C_sum Klasse_D_sum Klasse_E_sum etc...

A 5401 (xx%) 64 (x%) 25(x%) 1(x%)

B 62(x%) 1811(xx%) 45(x%) 11(x%) 2(x%)

C 30(x%) 77(x%) 1969(xx%) etc....

E
F

Re: Two dimensions in a crosstable

Tue, 26 Jun 2012 14:42:22 GMT

I have manged to get the data like I wanted it, but now the question how do I import the numbers simply from a table, now I just typed in the numbers.

Re: Two dimensions in a crosstable

christian77 — Tue, 26 Jun 2012 15:12:41 GMT

Hi:

Try pivoting. Drag the column as shown.