topic Re: Prob in QlikView

Prob

nikhilgarg — Thu, 29 Oct 2015 09:15:34 GMT

Hey,

I have a situtation of heirarchy, where i have to show all reporting managers.

I have attached snasphot.

I want Employee2, Employee3, EMployee4, Employee5 under same column as EmployeeName.

And Manager column is underlying expression.

Re: Prob

miguelbraga — Thu, 29 Oct 2015 09:41:06 GMT

Hi there,

Here take a look at these documents. It will help you understand better the hierarchy issue

Regards,

Re: Prob

miguelbraga — Thu, 29 Oct 2015 09:42:49 GMT

Hey again,

If my document didn't help you, can you please share your .qvd document?

Thanks,

Re: Prob

settu_periasamy — Thu, 29 Oct 2015 09:45:22 GMT

Hi Nikhil,

May be try to use Concatenate all the Employee Fields.

A:
LOAD * INLINE [
     Emp, Emp1, Emp2, Emp3
    1, 2, 3, 4
    3, 4, 5, 6
];

New:
Load Emp Resident A;
Concatenate
LOAD Emp1 as Emp Resident A;
Concatenate
LOAD Emp2 as Emp Resident A;
Concatenate
LOAD Emp3 as Emp Resident A;


DROP Table A;