Qlik Community

Ask a Question

Documents

QlikView documentation and resources.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER

Tree Visualisation

s_uhlig
Partner
Partner

Tree Visualisation

The attached example shows how to build a nested set based on a hierarchical data structure and its visualization on a scatter chart.

Attachments
Comments
s_uhlig
Partner
Partner

Hi Joe,

sorry for my late response. This is a Qlikview-document. The migration to Qlik-Sense doesn't convert the layout as described within the documentation.

0 Likes
qlikqool
Contributor II
Contributor II

QV11 SR12 fixes the scatter chart.  Qlik broke the functionality in between version 'upgrades'.  This is in response to the April message from Sven.

0 Likes
vijetasharma
Specialist
Specialist

Thanks for sharing documents,I have tried this application with my data but it's working only for single dimension what if I have two level hierarchy like I want to show states and city relationship like, State A is having 3 Cities a,b and c and likewise State B is having 2 cities d and e.In this case what should be the structure of code can anybody tell.

Regards,

Vijeta

0 Likes
s_uhlig
Partner
Partner

Hi Vijeta,

I think you will need an adjacency list like:

A ->

a -> A

b -> A

c -> A

B ->

d -> B

e -> B

but please understand, that I can't spend time on customisation this application for individual requirements

Best regards

Sven

0 Likes
niharika
Creator II
Creator II

Hi Sven,

Its really useful.

Earlier I had QlikView 11.2SR 7 and the chart was comming up but currently I am using QlikView 11.2SR 10 and now the chart displays an error that Drawing of Chart failed internally.

Is it because of updating the version?

Kindly help me with this.

Thanks,

Niharika

0 Likes
s_uhlig
Partner
Partner

Hi Niharika,

please have a look at

https://community.qlik.com/docs/DOC-2857#comment-38798

Best regards

Sven

Not applicable

This is definitely a good read. Now, I just have to find a good use for it in a dashboard I'm working on.

0 Likes
dmohanty
Partner
Partner

Hey s.uhlig‌,

Greetings!

Excellent piece of work here. As this has been long since this post has been created, I am using it now for one of my Tree Structure.

I wanted to end up the Tree, like a diamond structure, where the last node is common to its above 3 Parent Node.

From my Data below, I want CPA (single node/bubble) should be connected to RDC1, RDC2, RDC3. However my script creates 3 different CPA bubbles (i don't want this). I have attached the image below on how I am getting 3 different CPA bubbles (I don't want this).

Please help here, how a single CPA bubble can be created that connects to RDC1, RDC2, RDC3?

Thanks in advance.

DATA:

LOAD * INLINE [

    id, parentid, node

    1, 0, SCE

    2, 1, Receiving

    3, 2, RDC1

    4, 2, RDC2

    5, 2, RDC3

    6, 3, CPA

    7, 4, CPA

    8, 5, CPA

];

Snow_Tree.png

0 Likes
s_uhlig
Partner
Partner

Hi Dicky Mohanty,

within a tree data structure, each node has at most one parent. This post deals exclusively with the visualization of this kind of data structures. In your case, you have to look for some graph-visualisation technics and afaik, there is no native opportunity, but you can search the community for "graph extension" and find a plenty of posts.

If you need commercial support doing such visualisations, leave me a note. 


Best regards and happy new year

Sven 

0 Likes
ahaahaaha
Master
Master

Thanks for the useful information.

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2012-03-13 09:34 AM
Updated by: