topic Inverse of function crosstable() in QlikView

Inverse of function crosstable()

Thu, 30 Sep 2010 07:19:58 GMT

Hi all.

I have table

Manager Month Sales

Smith Jan 10

Smith Feb 20

I want to get:

Manager Jan Feb

Smith 10 20

Is it possible?

Thanx.

Inverse of function crosstable()

Miguel_Angel_Baeyens — Thu, 30 Sep 2010 07:40:47 GMT

Hello,

Try this way:

Raw:LOAD * INLINE [Manager, Month, SalesA, 1, 300A, 2, 200]; GENERIC LOAD * RESIDENT Raw;

Is that what you are looking for?

Inverse of function crosstable()

Thu, 30 Sep 2010 07:44:17 GMT

Just change the diagram type to pivot table (object properties/general) and you can move the month-dimension up as a head line.

Inverse of function crosstable()

Thu, 30 Sep 2010 08:03:08 GMT


Miguel A. Baeyens wrote:
Hello,
Try this way:
 <blockquote>Raw: LOAD * INLINE [ Manager, Month, Sales A, 1, 300 A, 2, 200 ]; GENERIC LOAD * RESIDENT Raw;<pre>

Is that what you are looking for?

Thank you.

Its not quite what i need because generic makes many tables and i want to get only one table.

Inverse of function crosstable()

Thu, 30 Sep 2010 08:06:47 GMT


DanielFunke wrote:
Just change the diagram type to pivot table (object properties/general) and you can move the month-dimension up as a head line. <div></div>

I need to transform table during reload not in the document. Anyway, thanx