Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
fanko1225
Contributor

Display straight table columns in Horizontal

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

   

CompanySUM_1 (MTD)SUM_1(YTD)SUM_1(LTD)SUM_2 (MTD)SUM_2(YTD)SUM_2(LTD)
ABC123789

Table B

   

CompanyMTDYTDLTD
ABC - SUM_1123
ABC - SUM_2789

Many Thanks,

Frank

Tags (2)
4 Replies
MVP & Luminary
MVP & Luminary

Re: Display straight table columns in Horizontal

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

- Marcus

fanko1225
Contributor

Re: Display straight table columns in Horizontal

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 MTDYTDLTD
ABCP&L147
ABCExpenses258
ABCFEES369
MVP & Luminary
MVP & Luminary

Re: Display straight table columns in Horizontal

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

fanko1225
Contributor

Re: Display straight table columns in Horizontal

Thanks Marcus. It's helpful to know.