topic Re: Crosstable to Pivot Table in QlikView

Crosstable to Pivot Table

Thu, 12 Jun 2014 14:15:04 GMT

Hi.

I'm trying to make an income statement report. For this, I'm making a pivot table with sales data, costs data and utility data. When I load the script, the table looks like this:

Month Sales Costs Utility

1 10 5 5

2 13 7 6

3 15 8 7

But I need that the table looks like this:

Month 1 2 3

Sales 10 13 15

Costs 5 7 8

Utility 5 6 7

How can I get that? Somebody suggests me use the function Crosstable, but I could not add it in my script. The code tha I'm using is this:

D_LIBROMAYOR:

CrossTable ([Nombre Cuenta Reporting],[Mvto Mes])

load * from

(qvd);

D_LIBROMAYOR_2:

LOAD

*, [Nombre Cuenta Reporting],

[Mvto Mes],

Mes

Resident D_LIBROMAYOR;

Anybody has any suggestion? Thank you for the collaboration.

Jairo Medina

Re: Crosstable to Pivot Table

IAMDV — Thu, 12 Jun 2014 17:21:55 GMT

Hi Jairo,

See the attachment and let me know if that's what you need?

Cheers,

www.QlikShare.com

Re: Crosstable to Pivot Table

Thu, 12 Jun 2014 17:48:11 GMT

Hi Deepak.

Yes. It is!!! Thank you.

Regards,

Jairo Medina

Re: Crosstable to Pivot Table

IAMDV — Thu, 12 Jun 2014 18:26:52 GMT

That's great!

Cheers,

Re: Crosstable to Pivot Table

Thu, 12 Jun 2014 22:16:29 GMT

Hi Deepak.

I have a question. How must I do this when the data come from a qvd? My plain file is:

[F/Contab],

Mes,

Año,

[F/Vcto],

Clase,

Grupo,

Cuenta,

[Sub Cuenta],

Auxiliar,

[Nombre Cuenta Reporting],

Clasificacion,

[Nombre Cuenta],

Serie,

[Nº documento],

[Nº folio],

[Nº trans#],

Comentarios,

[Cod Proyec],

[Ctro Benef],

Gerencia,

Ciudad,

Canal,

[Sub Canal],

[Nom Gerencia],

[Nom Ciudad],

[Nom Canal],

[Nom Subcanal],

[Cuenta de contrapartida],

[Nombre de la cuenta de contrapartida],

[Mvto Mes],

[Mvto Mes1],

[Codigo SN],

[Nombre SN],

F34,

F35,

NoName

FROM

(qvd);

The fields that I need to use are "Mes", "Nombre Cuenta Reporting", "Nombre Cuenta" and "Mvto Mes".

Thank you for your help.

Jairo Medina