Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jduluc12
Creator
Creator

Pivot table Hierarchy question

Hi,

My data set looks like this.

Parent             Child                 Price

 Cust1              Job1                 10

 Job1                Job2                 20

Job2                 Job3                  30

 

Now the report that I want is

 

Parent-Level-1      Parent-Level-2        Parent-Level-3        Parent-Level-4      Price

Cust1                         Job1                                                                                                         10

Cust1                         Job1                            Job2                                                                    20

Cust1                         Job1                            Job2                            Job3                              30

 

Is it possible to do it without any change in the load script?

Thanks,

Jean                                                                                          

 

 

Labels (2)
1 Solution

Accepted Solutions
agni_gold
Specialist III
Specialist III

2 Replies
agni_gold
Specialist III
Specialist III

I believe no.
jduluc12
Creator
Creator
Author

That's what I thought but wanted to ask experts before I conclude.