topic show table with dimensions and dimension values horizontally in QlikView

show table with dimensions and dimension values horizontally

felcar2013 — Tue, 03 Dec 2013 10:25:33 GMT

i want to show dimensions and their values horizontally. One dimension has vertical values

On the left side, there are two dimensions: Age Group and Gender. The dimensions values shall be shown horizontally and the dimensions shall appear one after the other. Is this possible?

QUARTER		2013 Q1	2013 Q2	2013 Q3	2013 Q4
AGE GROUP	18-25	23	54	26
	26-35	54	66	45
	36-45	12
	46-55
	56-65
	65+
GENDER	Male
	Female
	Not specified

Re: show table with dimensions and dimension values horizontally

rbecher — Tue, 03 Dec 2013 10:39:28 GMT

Hi Felipe,

just use a pivot table and pull the Gender dimension to the upper right heading part.

- Ralf

Re: show table with dimensions and dimension values horizontally

felcar2013 — Tue, 03 Dec 2013 11:02:32 GMT

thanks, but we need to have even not only two dimensions horizontally, the vertical (heading) one is the time. Gender must be on the left side

Re: show table with dimensions and dimension values horizontally

rbecher — Tue, 03 Dec 2013 11:09:11 GMT

Could you please upload an example QVW with sample data and the required layout as an Excel file od screenshot..

Re: show table with dimensions and dimension values horizontally

felcar2013 — Wed, 04 Dec 2013 14:24:03 GMT

thanks, but i really do not think it is possible to present "n" dimensions and their corresponding values horizontally in one table. I presented for this example 3 dimensions: quarter, age group and gender with its values, but the dimension number can be much greater. I have no sample data which is logical now and i cannot post real data

felipe