topic Re: Re: header problem in QlikView

header problem

Mon, 22 Sep 2014 11:35:28 GMT

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~

Re: header problem

Anonymous — Mon, 22 Sep 2014 11:38:10 GMT

please provide your qvw file

Re: header problem

avinashelite — Mon, 22 Sep 2014 11:41:59 GMT

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.

Re: header problem

MarcoWedel — Mon, 22 Sep 2014 12:09:00 GMT

Re: Spaltenüberschrift über mehrer Ebenen

Re: header problem

amit_saini — Mon, 22 Sep 2014 12:14:22 GMT

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,

Re: header problem

JonnyPoole — Mon, 22 Sep 2014 12:21:18 GMT

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.

Re: header problem

adhudson — Mon, 22 Sep 2014 13:01:33 GMT

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.

Re: Re: header problem

Mon, 22 Sep 2014 14:06:41 GMT

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.