topic Re: Crosstab help in QlikView

Crosstab help

Anonymous — Mon, 15 Apr 2013 14:42:30 GMT

Afternoon
all

Very
new to Qlikview having migrated from 10 year old Cognos [7.1]

Having
problems visualising how to get data in simple cross-tab forrmat with a list of
dates across the top, products down the left and values within the data [as
below, manually entered so excuse the formatting]

Header 1	2012 Apr	2012 May	2012 Jun	2012 Jul	2012 Aug	2012 Sep	2012 Oct	2012 Nov	2012 Dec	2013 Jan	2013 Feb	2013 Mar	MAT
Product 1				1.3	4.3	5.3	2.0	3.8	1.8	2.5	1.8	1.8	24.3
Product 2					0.4							0.5	0.9
Product 3				1.8	0.6			3.1	4.0	3.7	2.4	3.1	18.6
and so on ...				1.5	6.0	7.5	3.0						18.0
Totals	0.0	0.0	0.0	4.6	11.3	12.8	5.0	6.8	5.7	6.2	4.2	5.2	61.8

Apologies
if this is a simple question and I’m sure it has been asked many times before
but I cant see it easily in the history.

My data source consists of single flat invoice analysis file that’s has all the
required information in: Product, Year.Period and Qty as well as Customer so I can apply filters

Any help, even if its just pointing me to the same question previously asked and
now answered, would be greatly appreciated

Thanx

Andy

Re: Crosstab help

vikasmahajan — Mon, 15 Apr 2013 16:01:15 GMT

Hii

Find attachment of cross table details.

Vikas

Re: Crosstab help

Gysbert_Wassenaar — Mon, 15 Apr 2013 16:35:18 GMT

Add a new chart object and choose as chart type the pivot table (top right of the Chart Type icons). Add Product and Year.Period as dimensions and something like sum(Qty) as expression. Next you'll have to drag the Year.Period dimension to the right above the expression. When you see a horizontal blue line let go and the Year.Period dimension should now display horizontally. On the Presentation tab of the properties window you can select both dimensions and enable the option Show Partial Sums.

Re: Crosstab help

Anonymous — Tue, 16 Apr 2013 07:20:08 GMT

Excellent, sorted now. thanx