topic Re: Create 2 levels of grouping in QlikView

Create 2 levels of grouping

sacosta5 — Tue, 10 Nov 2015 15:43:10 GMT

Hi, I have the following information, and I nedd to create two levels of grouping:

1) level (NIVECODIGO)

2) dependence of the delegation father (DELE_NUM_PADRE)

The result to be obtained is the next in a pivot table:

Anyone have any suggestions?

THANK YOU!

swuehl — Wed, 11 Nov 2015 12:39:54 GMT

You may want to look into the HIERARCHY LOAD prefix:

miguelbraga — Wed, 11 Nov 2015 12:42:44 GMT

Hey Silvia Acosta,

Add something like this in your script:

If(NIVECODIGO = 1, DELE_NOM, null()) as Nivel1,

If(NIVECODIGO = 2, DELE_NOM, null()) as Nivel2,

If(NIVECODIGO = 3, DELE_NOM, null()) as Nivel3

And then construct a table like your result

Thanks,

sacosta5 — Wed, 11 Nov 2015 15:38:13 GMT

Hi Miguel,

Thanks for your suggestion, but it does not solve the second level of grouping. Also I need to use DELE_NUM_PADRE.

Silvia,

sacosta5 — Wed, 11 Nov 2015 15:40:44 GMT

Thanks Swuehl...

Thanks for your suggestion, I´ll take a look.

Silvia