topic Re: Pie Chart Help in QlikView

Pie Chart Help

Wed, 04 Dec 2013 19:15:17 GMT

Please find the screen shot of data..

My requirement Pie chart split by Total Performance rating.

I don't have performance rating field but i got that in my expression

Please find my requirement screen shot below.

Re: Pie Chart Help

Wed, 04 Dec 2013 19:48:52 GMT

Hi Reddy,

From your question it sounds like you want to know how to create this chart using Qlikview. Please find attached an example with your data tweaked a bit so that I can display all 3 performance ratings.

HIH,

Charles

Re: Pie Chart Help

albertovarela — Wed, 04 Dec 2013 19:50:29 GMT

Hello,

I would use a calculated dimension for the Performance rating

=if(TotalPerformanceScore <= 79

, 'Unsatisfactory'

, if(TotalPerformanceScore >= 90

,'Exceptional'

,'Acceptable'

)

then on the expression a count of Performance Score.

Other option is generate the Perf rating through the script.

Hope this helps.

Re: Pie Chart Help

fred_s — Wed, 04 Dec 2013 20:16:15 GMT

Hi Reddy,

In your script you could add an extra Load Statement like this:

Load *,
if([Total Performance score] < 80, 'Unsatisfactory',
if([Total Performance score] < 90, 'Acceptable',
'Exceptional'))
as [Total Performance Rating]
;

LOAD * INLINE [
    Supplier Group, Total Performance score
    3M, 60
    AAERO, 60
    ABORN, 97
    ACCELENT, 97
    ACCELENT, 60
    ACCELENT, 94
    ACCELENT, 60
];

Re: Pie Chart Help

marthacano01 — Wed, 04 Dec 2013 20:21:42 GMT

I hope it helps you. See into the expression, in the background color.

Re: Pie Chart Help

Wed, 04 Dec 2013 20:32:26 GMT

Their are many suppliers...And i don't have Total Performance score field

Re: Pie Chart Help

marthacano01 — Wed, 04 Dec 2013 20:48:55 GMT

If you see my app, I am using the average, Is it works for you?

Re: Re: Pie Chart Help

albertovarela — Wed, 04 Dec 2013 20:57:42 GMT

You can create it as a calculated dimension. Follow this:

or follow Fred's instruction to do it through the script

Re: Re: Pie Chart Help

Wed, 04 Dec 2013 21:10:19 GMT

i don't have the dimension Total Performance score