topic Re: chart in Water Cooler

chart

Sun, 08 Sep 2013 08:05:23 GMT

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.

Re: chart

Jason_Michaelides — Sun, 08 Sep 2013 14:50:01 GMT

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

Re: chart

Mon, 09 Sep 2013 04:25:19 GMT

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

Re: chart

Mon, 09 Sep 2013 04:27:07 GMT

hi Jason,

Thanx for your suggestion.

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

Re: chart

Jason_Michaelides — Mon, 09 Sep 2013 05:40:29 GMT

Let us know how you get on.

Re: chart

Mon, 09 Sep 2013 06:58:19 GMT

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

Re: chart

Jason_Michaelides — Mon, 09 Sep 2013 19:10:34 GMT

Can you post your application?

Re: chart

Tue, 10 Sep 2013 04:08:35 GMT

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 <

Re: Re: chart

Jason_Michaelides — Tue, 10 Sep 2013 08:15:16 GMT

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

Hope this helps,

Jason

Re: chart

Tue, 10 Sep 2013 09:28:23 GMT

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

Re: chart

Jason_Michaelides — Thu, 12 Sep 2013 09:50:19 GMT

That's a different question and should be in a new thread.

As a point of fact, you are supposed to mark the answer someone gives you as the correct one, not your own comment confirming their answer!

Re: chart

Thu, 12 Sep 2013 11:07:26 GMT

Sorry Jason it was done in mistake Sorry

On Thu, Sep 12, 2013 at 3:20 PM, Jason Michaelides <qcwebmaster@qlik.com