Qlik Community

Qlik Community Help Discussions

Discussion board for questions on how to use Qlik Community and its features.

Not applicable

chart

hi all,

i m making a pie chart with the data content i hav attached. it shows rating of employees. on selecting the rating it shows the name of employees having that rating. there are two table for it. should i hav to concatenate the table.

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: chart

hi Jason,

thanx for your support.

I made the change in Sheet2 and added EmpID in it. Made a Cross table join

of EmpID & Years.(I removed the EmpName, and Date of joining). Later I

tried to make a Pie chart making a group of Rating data and EmpName. But

nothing is coming in the chart. Help me.

On Sun, Sep 8, 2013 at 8:20 PM, Jason Michaelides

11 Replies
jason_michaelid
Honored Contributor II

Re: chart

Just load them separately and allow them to join on the common field. Although it is generally better to join on an ID field rather than name which may not be unique. Can your first sheet of dimension data not contain the EmpID?

Also, you may look to Crosstable() the second sheet fact data to allow it to expand more naturally and have "Year" as a selectable field.

Hope this helps,

Jason

Not applicable

Re: chart

hi

On Sun, Sep 8, 2013 at 8:20 PM, Jason Michaelides

Not applicable

Re: chart

hi Jason,

Thanx for your suggestion.

On Sun, Sep 8, 2013 at 8:20 PM, Jason Michaelides

jason_michaelid
Honored Contributor II

Re: chart

Let us know how you get on.

Not applicable

Re: chart

hi Jason,

thanx for your support.

I made the change in Sheet2 and added EmpID in it. Made a Cross table join

of EmpID & Years.(I removed the EmpName, and Date of joining). Later I

tried to make a Pie chart making a group of Rating data and EmpName. But

nothing is coming in the chart. Help me.

On Sun, Sep 8, 2013 at 8:20 PM, Jason Michaelides

jason_michaelid
Honored Contributor II

Re: chart

Can you post your application?

Not applicable

Re: chart

What I was capable of I did but I also had to make changes in the table. I

m posting the app here.

Thanx for yr support.

On Tue, Sep 10, 2013 at 12:40 AM, Jason Michaelides <

jason_michaelid
Honored Contributor II

Re: Re: chart

Here you go - I've updated your script to use Crosstable() as I suggested.

Hope this helps,

Jason

Not applicable

Re: chart

thnax jason,

As in the file there was experience. If I have to group the experience in

group of 1-5 yrs, 6-10 yrs, and +10 yrs. Plz tell me how?

Thanx ahead.

On Tue, Sep 10, 2013 at 1:45 PM, Jason Michaelides <qcwebmaster@qlik.com