topic Data Visualization using Sankey Chart in QlikView in QlikView

Data Visualization using Sankey Chart in QlikView

raimohith — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am new to Qlikview and I am trying to build a sankey chart using the below data. The requirement is to display the number of customers who are visiting 'department_from' first and then moving to 'department_to' using sankey chart in Qlikview.

When i am trying to display this, Qlikview begins loading for some time and then displays a message '. It keeps loading even if i click 'Yes' or 'No'. Please guide me on this.

Data:-

department_from	department_to	num_of_customers
Clothes	Kids	12
kids	Clothes	20

Qlikview Message:-

Note:

I am using Qlikview Personal Edition version 12.
I downloaded the sankey extension sankey.qar present in 'https://community.qlik.com/t5/QlikView-Documents/Slightly-Improved-Sankey-extension/tac-p/1496364'

Re: Data Visualization using Sankey Chart in QlikView

Gysbert_Wassenaar — Sun, 30 Dec 2018 11:33:57 GMT

That extension is over two years old and hasn't been updated. There's a good chance it's not compatible with your version of Qlikview. I suggest you try to contact the creator of the extension and ask him for help.

Re: Data Visualization using Sankey Chart in QlikView

raimohith — Sun, 30 Dec 2018 12:55:48 GMT

Hi @Gysbert_Wassenaar,

I tried with the few latest sankey chart extensions for Qlikview present in 'https://developer.qlik.com/garden', but no luck.

After a lot of trying and searching, I observed that a sankey chart cannot render data visually if the source values(department_from column in my example) and target values (department_to column in my example) forms a closed path/loop.

In my example,

the first row has source as 'Clothes' and target as 'Kids'
the second row has source as 'Kids' and target as 'Clothes'

So it would be a closed loop/path in my chart,something like shown in below pic.

The below image is a rough picture of the expected result.

Please correct me if I am wrong, but I am facing this issue only when the data is similar to the above scenario.

Also let me know if there is any workaround for this.