topic Re: Display straight table columns in Horizontal in QlikView

Display straight table columns in Horizontal

Anonymous — Mon, 22 Feb 2016 15:43:31 GMT

Hi All,

It's possible to display straight table columns in horizontal. I tried Presentation tab but didn't help. I want to display in Table B view. Please see below. Any help greatly appreciated!

Table A

Company	SUM_1 (MTD)	SUM_1(YTD)	SUM_1(LTD)	SUM_2 (MTD)	SUM_2(YTD)	SUM_2(LTD)
ABC	1	2	3	7	8	9

Table B

Company	MTD	YTD	LTD
ABC - SUM_1	1	2	3
ABC - SUM_2	7	8	9

Many Thanks,

Frank

Re: Display straight table columns in Horizontal

marcus_sommer — Mon, 22 Feb 2016 15:53:09 GMT

Change the chart-type to pivot-table and you could drag dimensions and expression like you want.

- Marcus

Re: Display straight table columns in Horizontal

Anonymous — Mon, 22 Feb 2016 16:24:09 GMT

Thanks Marcus. It works for MTD once I drag it as you said with Pivot table.

What I have is 3 SUM expressions with same Dimension for MTD, YTD, and LTD calculations. I want MTD, YTD, and LTD lables as my header and this dimension as the row.

Company		MTD	YTD	LTD
ABC	P&L	1	4	7
ABC	Expenses	2	5	8
ABC	FEES	3	6	9

Re: Display straight table columns in Horizontal

marcus_sommer — Mon, 22 Feb 2016 16:34:06 GMT

If you used MTD/YTD ... as a real dimension - maybe created withThe As-Of Table - you wouldn't need anything more. If not you need to create a calculated dimension, maybe per valuelist('MTD', 'YTD', 'LYTD') and which also must be integrated into your expressions, like:

pick(match(valuelist('MTD', 'YTD', 'LYTD'), 'MTD', 'YTD', 'LYTD'),

sum({ < FlagMTD = {1}>} [P&L]),

sum({ < FlagYTD = {1}>} [P&L]),

sum({ < FlagLYTD = {1}>} [P&L]))

- Marcus

Re: Display straight table columns in Horizontal

Anonymous — Mon, 22 Feb 2016 16:57:32 GMT

Thanks Marcus. It's helpful to know.