topic Re: Need help on Sankey in QlikView

Need help on Sankey

Wed, 25 Nov 2020 16:16:04 GMT

I am new to qlikview and need alot of help. I have the following table structure and need a sankey diagram to visualise the movement. But somehow it is now showing anything, when i turn off the webview, it shows "unknown charttype". can anyone help me please?

my table structure:

ID	CurrentJobTitle	PreviousJobTitle
101	Senior Manager	Manager
102	Architect	Analyst
103	Senior Executive	Executive
104	Director	Senior Analyst

The extension was gotten from https://bost.ocks.org/mike/sankey/

In the Webview mode, i am able to change the properties of the chart. But when i switch to normal view, it shows unknown charttype.

The expression is as follow:

Path (colon separated) = CurrentJobTitle : PreviousJobTitle

Frequency = Count(Distinct [ID])

This is nothing at all on the diagram.

Re: Need help on Sankey

adamdavi3s — Wed, 08 Mar 2017 10:18:29 GMT

Extensions are only available in webview I am afraid.

Do you get anything in the chart in webview?

Can you share your application and I will take a look and see

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

This will help users identify the answers should they come across this thread in the future.

Re: Need help on Sankey

Thu, 09 Mar 2017 01:19:55 GMT

Hi Adam, much appreciate your reply.

No, my chart is showing nothing, just blank canvas entirely.

In addition, i came across your newly improved version on Slightly Improved Sankey – Qlik and Dirty. Tried that extension but it is showing the same. Now sure what happen to my application though. hope you can help me

Attaching the sample dataset and the qlikview application.

Re: Need help on Sankey

adamdavi3s — Thu, 09 Mar 2017 09:12:59 GMT

Its the data it doesn't like for some reason, just trying to work out why, there is something the JS doesn't like, I suspect because sources can also be destinations and its creating some sort of weird loop in the script

Re: Need help on Sankey

Thu, 09 Mar 2017 13:07:52 GMT

‌Hi Adam, will you be able to share how you change the data so that the JS can read it and visualize in the chart? Or if you have done any different settings or expression? please share with me, thanks!

Re: Need help on Sankey

adamdavi3s — Fri, 10 Mar 2017 09:14:56 GMT

Hi Dylan,

I will, sorry going to look to day, just need some focused time on it as its going to be a pain to see quite what is happening!

Re: Need help on Sankey

adamdavi3s — Fri, 10 Mar 2017 09:42:58 GMT

Yeah its just the data, because it loops the script can't work out how on earth it should display it, which is fair enough really, it just gets stuck in a loop trying to work out the breadth of the item.

I just tweaked the script and prefixed the current and previous jobs and that worked, but its not ideal for what you want I am guessing, but I don't think the Sankey will ever display quite what you want

Re: Need help on Sankey

Fri, 10 Mar 2017 09:53:12 GMT

‌will you be able to share With me the 3 items that you've changed? The JS script, the excel as well as the Qlikview project Please?

Re: Need help on Sankey

adamdavi3s — Fri, 10 Mar 2017 13:22:23 GMT

Hi,

I didn't change anything in any of those just the load statement:

LOAD ID,

'C-'& CurrentJobTitle as CurrentJobTitle,

'P-'& PreviousJobTitle as PreviousJobTitle

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Need help on Sankey

Sat, 11 Mar 2017 02:04:24 GMT

Hi Adam, after changing the load script, it still doesn't work for me. It is still showing a entirely blank chart. Just to confirm again on how we actually put in the expression for the dimension. Did you put in the following expression under the properties:

Path (colon separated) = CurrentJobTitle : PreviousJobTitle

Frequency = Count(Distinct [ID])

Thank you once again.

Re: Need help on Sankey

adamdavi3s — Mon, 13 Mar 2017 07:28:19 GMT

Hi Dylan,

Sorry I was trying mine out using the separate source and destination fields.

However I don't think that will work, you'd need

LOAD ID,

'C-'& CurrentJobTitle as CurrentJobTitle,

'P-'& PreviousJobTitle as PreviousJobTitle,

PreviousJobTitle&':'&CurrentJobTitle as Path

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Need help on Sankey

Mon, 13 Mar 2017 07:47:10 GMT

Hi Adam, i am trying to replicate what you have done to get the sankey out. I have tried with the suggested code, and the extension with source and destination. It still doesn't work. I assume the expression will be like the following?

Source: PreviousJobTitle

Destination: CurrentJobTitle

Size: Count(ID)

Is there any usage for the Path?

Re: Need help on Sankey

adamdavi3s — Mon, 13 Mar 2017 07:51:23 GMT

Hi Dylan,

No you'd only need path using the old extension.

Please see the attached file which works fine on my system.

Kind regards

Adam

Re: Need help on Sankey

Mon, 13 Mar 2017 08:02:51 GMT

Hi Adam,

Really thank you for the help man.

Where can i find the attach file?

Re: Need help on Sankey

adamdavi3s — Mon, 13 Mar 2017 08:04:13 GMT

sorry too early, have attached it now

Re: Need help on Sankey

adamdavi3s — Mon, 13 Mar 2017 13:39:41 GMT

Has this all worked out for you now?

Re: Need help on Sankey

Mon, 13 Mar 2017 13:45:38 GMT

‌Hi Adam, unfortunately I can't open the Qlik project from you as I have used up the quota for personal edition. Can you share the expression that you used? After using your load script and the following expression, I still get a blank chart.

Source: PreviousJobTitle

Destination: CurrentJobTitle

Size: Count(ID)

Re: Need help on Sankey

adamdavi3s — Mon, 13 Mar 2017 14:00:34 GMT

Hi Dylan,

Yes thats exactly what I am using plus the attached .qar file.

I would suggest

1- install the qar

2- create a brand new dashboard

and see if that works

Re: Need help on Sankey

Tue, 14 Mar 2017 01:07:19 GMT

This is working! Thank you!