topic Re: How to create custom rows in one straight table in QlikView

How to create custom rows in one straight table

Thu, 25 Apr 2013 23:06:20 GMT

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!

Re: How to create custom rows in one straight table

sibin_jacob — Fri, 26 Apr 2013 07:17:04 GMT

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

Re: How to create custom rows in one straight table

Fri, 26 Apr 2013 21:15:05 GMT

What an elegance solution.

Thank you!