header problem

[#1]

hi. im h.s from S.Korea

im a QlikView beginner.

i have one question about header.

i have one straight table. below~

A     B     C    D    E      1    2     3      one    two   three four  <== column name

12   22   10   13  10     12  14   13     11     12      14   15    <==data

10   20   11   10  10     12  15   17     12     13      14   10

20   13   14   10  15     10  10   20     15     10      11   10

but i want to have table like this.

          alphabet                number          statement                <==header

A     B     C    D    E      1    2     3      one    two   three four  <== column name

12   22   10   13  10     12  14   13     11     12      14   15    <==data

10   20   11   10  10     12  15   17     12     13      14   10

20   13   14   10  15     10  10   20     15     10      11   10

but i can make header => alphabet, number, statement.

i also use inline statement.. it doen't work.

how to make header. like this.

please let me know~

[Anonymous]

please provide your qvw file

[avinashelite]

Hi Hyunseok,

As per my knowledge, we cannot achieve this kind of header in qlikview.

Try to use Text Box and make it as header instead of the chart header. 

[MarcoWedel]

Re: Spaltenüberschrift über mehrer Ebenen

[amit_saini]

Lee,

Agree with Avinash , this kind of header is not possible . better use Text box to show these headers .

Something similar I have created , see below:

Thanks,

AS

[JonnyPoole]

This is possible in QLIK but not through the UI and not with a straight table. You would have to use a pivot table and structure the data model accordinly with a  lookup table like this

HeaderSummary     HeaderDetail

Alphabet               A

Alphabet               B

Alphabet               C

Number                 1

Number                 2

Number                 3

Statement               One

Statement               Two

Statement               Three

In your main table you need HeaderField2 and the associated measure values like this (and any other fields). You can still have other lookup tables, calendar and anything else you need. Include an identifying field name for the row.

HeaderDetail          MeasureValue     Row

A                             100                      1             

A                             105                      1       

B                              50                       1

C                              50                       1

1                               252                     1

2                               14                      1

3                                34                     1

One                           5                         1

Two                             7                       1

Three                            3                     1

in the Pivot table,  Row is the row dimension. HeaderSummary is the column dimension and HeaderDetail is a nested Column dimension. You can hide the row dimension by changing the text and a few other techniques to make it look like a straight table.

Don't do this if you expect 10,000's of records in the pivot table as performance will take a hit.

[adhudson]

Hi HS,

Your requirement is very new and I gave it a try for that.

The solution which I have derived might look complicated. Unfortunately this is the only solution I can think of right now.

It might not be exactly same as required.

Regards,

Andrew Hudson.

[#8 · Accepted solution]

example QVW file .

there are 8 columns. Product Group/Product Sub Group/ Item Desc / Sales Accumulate / Sales(K)/Qty(K)/Margin(K)/Margin%

but i want to have

                                     product type                /     Sales Accumulate  /                 K             

Product Group/Product Sub Group/Item Desc / Sales Accumulate / Sales(K)/Qty(K) / Margin(K)    

how can i make this Header -->     Product Type  /  Sales Accumulate  /   K   / %

this is examples.  there is no mean (Header names)

please let me know.