Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

header problem

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~

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

7 Replies
konstantin
Creator III
Creator III

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

amit_saini
Master III
Master III

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
Employee
Employee

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
Creator II
Creator II

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.

Not applicable
Author

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.

View solution in original post