topic Re: need help to create table like attached image in QlikView

need help to create table like attached image

ananyaghosh — Tue, 12 May 2015 12:30:23 GMT

Hi,

I have attached an excel sheet and based on that I have to create a table like this:

Where

KIP = Value Per SQ Ft and other columns behind the Value Per SQ Ft.

Please give me a suggestions

Re: need help to create table like attached image

Anonymous — Tue, 12 May 2015 12:58:52 GMT

It looks like a pivot table with dimensions KPI Name and Quarter, and expressions Portfolio and Bench mark.

Re: need help to create table like attached image

Tue, 12 May 2015 13:03:06 GMT

The only tricky part is maybe the dimensions sorting but that should be manageable with the expression sort.

Re: need help to create table like attached image

ananyaghosh — Tue, 12 May 2015 13:15:51 GMT

Can u give me QVW showing the table in proper format? the main problem is showing two header under a main header for example 2015 Q2 have two sub heading portfolio and benchmark.

Re: need help to create table like attached image

Anonymous — Tue, 12 May 2015 13:20:09 GMT

See attached

Two dimensions, one of them is on top (Dim3), and two expressions.

Re: need help to create table like attached image

Tue, 12 May 2015 13:28:21 GMT

Couple of QVW example here

Re: Merge headers in pivot table

merge headers in pivot table

Best one which i like personally, and is simple to understand is

Re: adding manual field header to pivot table

Multiple Header Rows.qvw

Hope this helps...

Regards,

Re: need help to create table like attached image

ananyaghosh — Wed, 13 May 2015 12:00:37 GMT

Hi,

How can you create Three columns X, Y and Z in pivot table? Can u give me some screenshot, how to do it? because you have specified only two expressions and that expressions are repeated for X, Y and Z columns. So please give me some instructions of how to do it.

Please....................