Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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);
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?
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
Hi Adam,
Really thank you for the help man.
Where can i find the attach file?
sorry too early, have attached it now
Has this all worked out for you now?
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)
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
This is working! Thank you!