Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
fanko1225
Creator
Creator

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

4 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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

- Marcus

fanko1225
Creator
Creator
Author

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
marcus_sommer
MVP & Luminary
MVP & Luminary

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
Creator
Creator
Author

Thanks Marcus. It's helpful to know.