topic Re: N-level hierarchy in QlikView

N-level hierarchy

Thu, 21 Jan 2016 16:58:55 GMT

i have one problm pls help me... this is N-level hierarchy below fields. in script level i want N-level hierarchy script

PSPHI

POSNR

RIGHT

Thu, 21 Jan 2016 18:43:27 GMT

Can you please explain the requirement clearly with sample data.

HirisH_V7 — Thu, 21 Jan 2016 18:53:40 GMT

Hi,

May be like this,

Table:

Hierarchy (PSPHI,UP,POSNR,RIGHT QuantityPath, '/', Depth)

LOAD PSPHI,

PSPHI as UP,

POSNR,

Text(RIGHT) as RIGHT

FROM BOM.xlsx (ooxml, embedded labels, table is Sheet1);

HTH,

-Hirish

MarcoWedel — Mon, 25 Jan 2016 23:51:39 GMT

please close some of your open threads by selecting correct answers (or thread assumed answered).

thanks

regards

Marco