Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There
I have requirement to show dimensions as Tree View using Straight Table. Can you please suggest.
Thanks in advance,
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
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.
Thanks for quick reply, can you guide me on extensions?
No, I can't. You'll have to teach that yourself: QlikView Extension tutorials, documentation and examples - The Qlik Fix! The Qlik Fix!
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