topic Re: Making Graph out of Comma Separated Values in QlikView

Making Graph out of Comma Separated Values

Wed, 16 Jul 2014 04:48:31 GMT

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

Re: Making Graph out of Comma Separated Values

Wed, 16 Jul 2014 04:53:44 GMT

Hi Pradeep,

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

Thanks

Prateek

Re: Making Graph out of Comma Separated Values

engishfaque — Wed, 16 Jul 2014 06:26:40 GMT

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

Re: Making Graph out of Comma Separated Values

Wed, 16 Jul 2014 06:27:53 GMT

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

Re: Making Graph out of Comma Separated Values

Wed, 16 Jul 2014 09:56:49 GMT

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

Re: Making Graph out of Comma Separated Values

Wed, 16 Jul 2014 10:50:37 GMT

Hi,

Can u attach your sample data ?

Re: Re: Making Graph out of Comma Separated Values

Wed, 16 Jul 2014 10:58:29 GMT

Emp ID	Languages Known	Dept ID
1234	English,Hindi	D1
1235	English,French	D2
1236	French,German	D1
1237	Hindi	D2

Re: Making Graph out of Comma Separated Values

Wed, 16 Jul 2014 11:12:58 GMT

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