topic Re: Issue with Cross table in QlikView

Issue with Cross table

Mon, 16 Feb 2015 05:38:15 GMT

Hi All,

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

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:

Thanks.

-Sindhu.

prma7799 — Mon, 16 Feb 2015 05:45:02 GMT

PFA

prma7799 — Mon, 16 Feb 2015 05:50:46 GMT

jonathandienst — Mon, 16 Feb 2015 05:51:40 GMT

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

Mon, 16 Feb 2015 06:24:46 GMT

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.