Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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~
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.
please provide your qvw file
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.
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
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.
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.
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.