Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Making Graph out of Comma Separated Values

Dear QlikViewers,

I have following data set:

Employee IDLanguages Known
1234English, Hindi
1235English, Hindi, French
1236French, German
1237Hindi, German
1238English, 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

7 Replies
Not applicable
Author

Hi Pradeep,

Not able to open it as I am using desktop version.

Thanks

Prateek

engishfaque
Specialist III
Specialist III

Dear Prateek,

Solved problem, kindly find attached screen shot for your understanding.

Please mark as a correct answer and close the thread.

img-1.png

img-2.png

img-3.png

Kind regards,

Ishfaque Ahmed

Not applicable
Author

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

bar-chart.png

Regards,

Vivek

Not applicable
Author

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

Not applicable
Author

Hi,

Can u attach your sample data ?

Not applicable
Author

Emp IDLanguages KnownDept ID
1234English,HindiD1
1235English,FrenchD2
1236French,GermanD1
1237HindiD2
Not applicable
Author

Hi,

for me its working fine

Have a look

lang.png

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