Issue with Cross table

[#1]

Hi All,

I have an excel sheet where I have a account no. and Product type listed as below:

Account	INT	TP	PP	MCB	MROS
123	4		1		2
456		3	1	2
789					6
00123	5	1
000156		3		2

Here Product types are INT,TP,PP MCB, MROS.

Now in qlikview I need to need them under a dimension called Product Type so that I can show it in a list box.

So when I select on any Product Type it should show me the count wrt to the account.

It should be sumthing like below:

Account	Product Type	Count
123	INT	4
123	PP	1
123	MROS	2
456	TP	3
456	PP	1
456	MCB	2

Thanks.

-Sindhu.

[prma7799 · Accepted solution]

PFA

[prma7799]

[jonathandienst]

Hi

Load the data with a cross table load:

CrossTable([Product Type], Amount)

LOAD Account,

  INT,

  TP,

  PP,

  MCB,

  MROS

From ........

Now create straight table with Account and Product Type as dimensions and Sum(Amount) as expression.

HTH

Jonathan

[#5]

Thats exactly what I want..

Thanks for your help.

What if I want to do the reverse ie. row values to appear as the field names.

Regards,

Sindhu.