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: 
ashishpalkar
Creator III
Creator III

Tree View using Straight Table

Hi There

I have requirement to show dimensions as Tree View using Straight Table. Can you please suggest.

Thanks in advance,

1 Solution

Accepted Solutions
MarcoWedel

Hi,

one solution could be to extract the different path nodes into seperate fields in the load script and to use those fields as dimensions in a pivot table:

QlikCommunity_Thread_168395_Pic1.JPG

QlikCommunity_Thread_168395_Pic2.JPG

table1:

LOAD *,

    Ceil(Rand()*100) as fact

Inline [

path

AAA

AAA/BBB

AAA/BBB/CCC

AAA/BBB/DDD

AAA/CCC

AAA/CCC/DDD

AAA/CCC/EEE

BBB

BBB/BBB

BBB/BBB/CCC

BBB/BBB/DDD

BBB/CCC

BBB/CCC/DDD

BBB/CCC/EEE

];

tabSelectionPath:

Generic

LOAD Distinct

    path,

    IterNo(),

    SubField(path,'/',IterNo())

Resident table1

While IterNo()<=SubStringCount(path,'/')+1;

hope this helps

regards

Marco

View solution in original post

4 Replies
Gysbert_Wassenaar

That's not possible. Try using a pivot table instead. You can expand and collapse its dimensions. That's the best you can get unless you're willing to code an extension.


talk is cheap, supply exceeds demand
ashishpalkar
Creator III
Creator III
Author

Thanks for quick reply, can you guide me on extensions?

Gysbert_Wassenaar

No, I can't. You'll have to teach that yourself: QlikView Extension tutorials, documentation and examples - The Qlik Fix! The Qlik Fix!


talk is cheap, supply exceeds demand
MarcoWedel

Hi,

one solution could be to extract the different path nodes into seperate fields in the load script and to use those fields as dimensions in a pivot table:

QlikCommunity_Thread_168395_Pic1.JPG

QlikCommunity_Thread_168395_Pic2.JPG

table1:

LOAD *,

    Ceil(Rand()*100) as fact

Inline [

path

AAA

AAA/BBB

AAA/BBB/CCC

AAA/BBB/DDD

AAA/CCC

AAA/CCC/DDD

AAA/CCC/EEE

BBB

BBB/BBB

BBB/BBB/CCC

BBB/BBB/DDD

BBB/CCC

BBB/CCC/DDD

BBB/CCC/EEE

];

tabSelectionPath:

Generic

LOAD Distinct

    path,

    IterNo(),

    SubField(path,'/',IterNo())

Resident table1

While IterNo()<=SubStringCount(path,'/')+1;

hope this helps

regards

Marco