Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Pie chart help

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.

1 Solution

Accepted Solutions
vijay_iitkgp
Valued Contributor

Pie chart help

Hi,

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

3 Replies
vijay_iitkgp
Valued Contributor

Pie chart help

Hi,

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

MVP
MVP

Pie chart help

Hi,

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

Regards,

Jagan.

Not applicable

Pie chart help

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

Community Browser