Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear QlikViewers,
I have following data set:
Employee ID | Languages Known |
---|---|
1234 | English, Hindi |
1235 | English, Hindi, French |
1236 | French, German |
1237 | Hindi, German |
1238 | English, French |
Now I want to make a Bar-chart out of it saying: "English - 3, Hindi - 3, French - 3, German -2"
Thanks in Advance
Prateek
Hi Pradeep,
Not able to open it as I am using desktop version.
Thanks
Prateek
Dear Prateek,
Solved problem, kindly find attached screen shot for your understanding.
Please mark as a correct answer and close the thread.
Kind regards,
Ishfaque Ahmed
Hi Parteek,
While Loading Data Try this script
Tab1:
LOAD [Employee ID],
[Languages Known]
FROM
[http://community.qlik.com/thread/125832]
(html, codepage is 1252, embedded labels, table is @1);
Load [Employee ID],
[Languages Known],
SubField([Languages Known],', ') as [Languages Known1]
Resident Tab1;
Drop Table Tab1;
and then make a bar chart
in dimension put [Language Known1] and
in expression give count([Employee ID])
Your char will come like this
Regards,
Vivek
Vivek, Ishfaque,
Thanks for the tip. However now I am facing another problem. In the same table, if I add a 3rd field like Department (Values: Dep1, Dep2) and on my dashboard select the Department from some other graph on the same dashboard, the count in this graph not getting updated.
Thanks
Prateek
Hi,
Can u attach your sample data ?
Emp ID | Languages Known | Dept ID |
---|---|---|
1234 | English,Hindi | D1 |
1235 | English,French | D2 |
1236 | French,German | D1 |
1237 | Hindi | D2 |
Hi,
for me its working fine
Have a look
Check whether you are taking dept id from the same table or if yo are taking from another table check whether that dept id is associated with this table or not.
Regards,
Vievk