topic Re: Tree View using Straight Table in QlikView

Tree View using Straight Table

ashishpalkar — Mon, 15 Jun 2015 16:30:27 GMT

Hi There

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

Thanks in advance,

Re: Tree View using Straight Table

Gysbert_Wassenaar — Mon, 15 Jun 2015 16:36:45 GMT

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.

Re: Tree View using Straight Table

ashishpalkar — Mon, 15 Jun 2015 16:40:58 GMT

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

Re: Tree View using Straight Table

Gysbert_Wassenaar — Mon, 15 Jun 2015 16:45:09 GMT

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

Re: Tree View using Straight Table

MarcoWedel — Mon, 15 Jun 2015 23:05:07 GMT

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:

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