Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

tomoyuki111
New Contributor

How to create a Recursive chart?

Hi,

I'm trying to create chart <Image1> and <Image2> from below <data>.

<Data>
load * inline [
Date,D1,D2,D3,D4,Number,Sales
201101,Parent,Z,Rock,Sven,1,1000
201101,Parent,Z,Rock,Sven,2,2000
201101,Parent,Z,Rock,Sven,3,3000
201101,Parent,Z,Joan,Sven,4,4000
201101,Parent,Y,Rock,Sven,5,5000
201102,Parent,Z,Rock,Sven,6,6000
201102,Parent,Z,Ingrid,Sven,7,7000
201102,Parent,Z,Joan,Sven,8,8000
201102,Parent,Y,Rock,Sven,9,9000
201102,Parent,X,Rock,Sven,10,10000
201102,Parent,Z,Joan,Sven,11,11000
201102,Parent,Y,Rock,Sven,12,12000
201102,Parent,X,Rock,Sven,13,13000
201101,Child,Z,Helen,Joan,14,14000
201101,Child,Y,Helen,Rock,15,15000
201105,Child,Z,Helen,Rock,16,16000
201102,Child,Z,Binh,Rock,17,17000
201102,Child,A,Paul,Joan,18,18000
];

<Image 1>
-> Select None.
--------------------------------------------------
D2,    D3,  P_Number, P_Sales, C_Number, C_Sales
Z,   Rock,       12,   12000,       33,   33000
Z,   Joan,       23,   23000,       32,   32000
Z, Ingrid,        7,    7000,        -,       -
Y,   Rock,       26,   26000,       15,   15000
X,   Rock,       23,   23000,        -,       -
--------------------------------------------------

<Image 2>
-> Date 201101 Selected.
--------------------------------------------------
D2,    D3,  P_Number, P_Sales, C_Number, C_Sales
Z,   Rock,        6,    6000,        -,       -
Z,   Joan,        4,    4000,       14,   14000
Y,   Rock,        5,    5000,       15,   15000
--------------------------------------------------

first, I separate <data> by D1 value. and create Parent/Child table and Concate those tables by D3/D4 value.
but when create <Image 1>, Child table value are missing.

Any thoughts or ideas greatly appreciated.

please help.

thanks