topic Re: Doubts about Cross Table in QlikView

Doubts about Cross Table

Thu, 29 May 2014 05:28:25 GMT

Hi Friends,
for following example how to create the cross tables.

Product ID | Product Name|Jan-12|Feb-12|Mach-12| Jan-13|

1 | TV | 40 | 23 | 50 | 25 |

Expected Result:

1 | TV | Jan-12| 40 | Jan- 13| 25 |

Thank you,

Re: Doubts about Cross Table

jagan — Thu, 29 May 2014 06:23:34 GMT

Hi Vijay,

Try like this

Temp:

CrossTable(Months, Value, 2)

LOAD

FROM DataSource;

Data:

LOAD

Year(Date) AS Year;

LOAD

Date(Date#(Months, 'MMM-YY')) AS Date

RESIDENT Temp;

DROP TABLE Temp;

Now in Pivot Table

Dimension: Product ID, Product Name, Year, Months

Expression : Sum(Value)

Now drag (Pivot) Year and Month column to the top of the table.

Regards,

jagan.

Re: Doubts about Cross Table

Thu, 29 May 2014 06:36:33 GMT

But in the given scenario the months are given in a row and doesnt content any coloumn name so while loading how should i load it

Re: Doubts about Cross Table

sasikanth — Thu, 29 May 2014 06:41:56 GMT

HI Vijay

Try some thing like below

CrossTable(year,sales,2)
LOAD * Inline [
Product ID , Product Name,Jan-12,Feb-12,Mach-12, Jan-13,
1 , TV, 40 ,3,50, 25

];

Re: Doubts about Cross Table

jagan — Thu, 29 May 2014 07:44:51 GMT

Hi,

That is why we are using the CrossTable(), which unpivots (Rows to Columns) the data. Please check for CrossTable example in Qlikview help file or community.

Regards,

Jagan.