Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can any one help me about this attached report format.
HI,
Try this,
Cross table(Name,1)
Load
Field,
Jan
Feb,
.,
.
From
xyz.qvd;
Srinivasan,
A cross table is a common type of table featuring a matrix of values between two orthogonal lists of header data. It could look like the table below:
Example:
Year | Jan | Feb | Mar | Apr | May |
1991 | 45 | 65 | 78 | 12 | 78 |
1992 | 11 | 23 | 22 | 22 | 45 |
1993 | 65 | 56 | 22 | 79 | 12 |
1994 | 65 | 24 | 32 | 78 | 55 |
1995 | 45 | 56 | 35 | 78 | 68 |
If this table is simply loaded into QlikView, the result will be one field for Year and one field for each of the months. This is generally not what you would like to have. One would probably prefer to have three fields generated, one for each header category (Year and Month) and one for the data values inside the matrix.
This can be achieved by adding the crosstable prefix to your load or select statement.The statement for loading this cross table could be:
crosstable (Month, Sales) load * from a.csv;
The result in QlikView would be as follows:
Year | Month | Sales |
1991 | Jan | 45 |
1992 | Feb | 11 |
1993 | Mar | 65 |
1994 | Apr | 65 |
1995 | May | 65 |
23 | ||
56 | ||
24 |
See the attachment for example.
Thanks,
AS
Hi
I assume that you are asking how to create such a view on the front end?
HTH
Jonathan
Please see the attached