topic Re: Cross tab like report in QlikView

Cross tab like report

Fri, 31 Oct 2014 06:37:13 GMT

Can any one help me about this attached report format.

Re: Cross tab like report

rohit214 — Fri, 31 Oct 2014 07:04:39 GMT

HI,

Try this,

Cross table(Name,1)

Load

Field,

Jan

Feb,

From

xyz.qvd;

Re: Cross tab like report

Fri, 31 Oct 2014 07:04:41 GMT

Hi,

Try to use
Generic load with your data.

What is Generic load and when we used Generic load.

Re: Cross tab like report

amit_saini — Fri, 31 Oct 2014 07:12:20 GMT

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:

a.csv

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,

Re: Cross tab like report

jonathandienst — Fri, 31 Oct 2014 07:15:23 GMT

I assume that you are asking how to create such a view on the front end?

Create a pivot table with dimensions for name and month.
Add your expression. Click OK to complete the pivot.
Expand the pivot so you can see both dimensions.
Click and drag the header for the second dimension to the top of the table (the red arrow will turn horizontal).Now release.

HTH

Jonathan

Re: Cross tab like report

Kushal_Chawda — Fri, 31 Oct 2014 07:21:47 GMT

Please see the attached