Pie chart help

Tue, 21 Feb 2012 11:53:22 GMT

I'm trying to see the total revenue generated by each of courses in a given month. I am then putting the information into a pie chart to show the six highest grossing courses. The problem I am having is that I want to show the proportion of total revenue each course contributes in % terms and not, as it currently is, in real £ terms.

dimension: Course Name

expression:

((Sum({<[Pipeline Year]={$(varCurrentYear)}, [Pipeline Month]={$(varCurrentMonth)}, COUNTY -={'JSY','GNY','IOM','NHQ'}>} [InCompany Revenue]) +

Sum({<[Pipeline Year]={$(varCurrentYear)}, [Pipeline Month]={$(varCurrentMonth)}, COUNTY -={'JSY','GNY','IOM','NHQ'} >} [Scheduled Revenue])))

Is there a way to edit my current expression so that the result is shown in % terms, rather than having to re-write the expression?

Thanks.

Pie chart help

vijay_iitkgp — Tue, 21 Feb 2012 12:00:02 GMT

Hi,

Go to Properties---->Expression and check relative.

Pie chart help

jagan — Tue, 21 Feb 2012 12:00:16 GMT

Hi,

Select the 'Relative' option in Expression tab in Chart Properties. This will give the percentage.

Regards,

Jagan.

Pie chart help

Tue, 21 Feb 2012 12:02:44 GMT

Brilliant! Thank you both. I didn't know it was so simple!!!

topic Pie chart help in QlikView

Pie chart help

Pie chart help

Pie chart help

Pie chart help