Pie Chart Help

[#1]

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.

[#2]

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

[albertovarela]

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.

[fred_s]

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
];

[marthacano01]

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

[#6]

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

[marthacano01]

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

[albertovarela]

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

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

[#9]

i don't have the dimension Total Performance score