topic Re: Hirarchy in one column in QlikView

Hirarchy in one column

Thu, 11 Apr 2013 17:24:43 GMT

Hi All,

do you any way to present hierarchical data in one column? It cannot be a treeview and has to be dynamic i.e. if there is another dim e.g. D it will appear in the first set after C.

Dim	Value
A	2
B	4
C	6
Total (A+B+C)	12
G	-3
H	-5
Total (A+B+C+G+H)	4
I	7
Total (A+B+C+G+G+H+I)	11

Regards,

Przemek

Re: Hirarchy in one column

Sun, 14 Apr 2013 07:25:36 GMT

Any idea?

Re: Hirarchy in one column

Sun, 14 Apr 2013 08:27:53 GMT

Hi ,

Do you wanted to have this Table Data in Script Table or Chart Straight Table?

//Yusuf

Re: Hirarchy in one column

Sun, 14 Apr 2013 09:38:00 GMT

Hi yusuf,

chart. I need to present profit & loss report without adding extra columns in the chart - have the structure in one column only.

Regards,

Przemek

Re: Hirarchy in one column

vinieme12 — Sat, 02 Jul 2016 18:08:11 GMT

Hi,

Hopefully the attached would give you some insight on how to work with your data.

The attached has been made assuming each of the calculations are separate dimensions.

Re: Hirarchy in one column

vinieme12 — Sun, 03 Jul 2016 07:20:13 GMT

Here is another solution if all your Attributes A,B,G,H etc are in a single column

LOAD Type,

Values

FROM

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

CONCATENATE

LOAD

'Total(A+B+C)' as Type,

sum(Values) as Values

FROM

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq)

WHERE wildmatch(Type,'A','B','C')>0;

CONCATENATE

LOAD

'Total(A+B+C+G+H)' as Type,

sum(Values) as Values

FROM

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq)

WHERE wildmatch(Type,'I')=0;

CONCATENATE

LOAD

'TOTAL' as Type,

sum(Values) as Values

FROM

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

TypeSortOrder:

LOAD * Inline [

Type,SortOrder

A,1

B,2

C,3

Total(A+B+C),4

G,5

H,6

Total(A+B+C+G+H),7

I,8

TOTAL,9

];