How to create custom rows in one straight table

[#1]

Hello QlikCommunity,

I'm new to QlikView and wanted to know how to create a table with 4 custom rows.

Here is what I want the final result to look like.

Statistics	2011	2012	2013 YTD	2013Q1	2013Q2 YTD
# of hours	4,000	3,500	2,000	1,000	1,000
# of cases open	1,000	1,200	900	400	500
# of cases closed	800	1,000	300	100	200
# of issues	200	200	600	300	300

[# of hours], [# of cases open], [# of cases closed] and [# of issues] are calculated measures, and they are not loaded with the script.

Currently I'm creating 4 seperate straight tables - one custom row per table with same column headings. The problem with this approach is that I can't combine 4 straight tables into one and use just one comon headers for all rows. This seems such a trivial problem. It's really easy to do in Excel or SAP BO Webi, but I can seem to find an efficient and effective way to present the information to the user.

Any help would be greatly appreciated.

Thanks!

[sibin_jacob · Accepted solution]

Create a inline table with the field static_name. static_name column contain values # of hours, # of cases open ...

Then use dimension as static_name.

In expression you need to write expression like this

first expression for 2011

If (rowno()=1,

formula for hours,

if(rowno()=2,

formula for open cases,

if(rowno()=3,

formula for closed cases,

if(rowno()=4,

formula for issues))))

Thanks

Sibin jacob.c

[#3]

What an elegance solution.

Thank you!