Need help on Sankey

[#1]

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.

[adamdavi3s]

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);

[#3]

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?

[adamdavi3s]

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

[#5]

Hi Adam,

Really thank you for the help man.

Where can i find the attach file?

[adamdavi3s]

sorry too early, have attached it now

[adamdavi3s]

Has this all worked out for you now?

[#8]

‌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)

[adamdavi3s · Accepted solution]

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

[#10]

This is working! Thank you!