Creating Table Row Headers in QlikView

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello QC,

QlikView Newbie here. Just started learning the program a few weeks ago and after watching many videos and reading content I've come across an issue I can't seem to solve or find a solution to (partially because I cannot figure out how to ask the question well).

So here's my issue:

I need to create a standard table with both Column AND Row Headers. I understand the column headers will be created based on the data pull, but I cannot figure out how to write-in manual Row Headers.

I need to label individual rows with Titles to reflect certain functions. The table I am creating is composed almost entirely of calculations (other than maybe two rows). Kind of like this:

Year of First Gift	Calculation	2013	2014	2015	2016
2013	"CalcLabel1"	=Field1/Field2 for 2013	=Field1/Field2 for 2014	=Field1/Field2 for 2015	=Field1/Field2 for 2016
	"CalcLabel2"	=Field2/Field4 for 2013	=Field2/Field4 for 2014	=Field2/Field4 for 2015	=Field2/Field4 for 2016
	"CalcLabel3"	"	"	"	"
	"CalcLabel4"	"	"	"	"
2014	"CalcLabel1"	=Field1/Field2 for 2013
	"CalcLabel2"	=Field2/Field4

The Calculation Column is where I need to put in labels for my rows. There's a set of calculations we want to look at for each year (Columns 3-6) based on when a donor first gave (Column 1). This seems like a Pivot Table, but I can't figure out how to insert the Row Labels.

If I need to provide more information, please let me know. Thanks in advance!

Re: Creating Table Row Headers in QlikView

Gysbert_Wassenaar — Mon, 22 Aug 2016 15:44:40 GMT

See this blog post: ValueList() – For those tricky situations

Re: Creating Table Row Headers in QlikView

Anonymous — Mon, 22 Aug 2016 15:47:35 GMT

Will do, Thanks gwassenaar‌!

Re: Creating Table Row Headers in QlikView

effinty2112 — Mon, 22 Aug 2016 15:54:30 GMT

Hi Weston,

A pivot table with dimensions [Year of First Gift], Year and four expressions should do it. You can label the expressions how you please.

Cheers

Andrew

topic Re: Creating Table Row Headers in QlikView in QlikView

Creating Table Row Headers in QlikView

Re: Creating Table Row Headers in QlikView

Re: Creating Table Row Headers in QlikView

Re: Creating Table Row Headers in QlikView