Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

0 Replies