Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pie Chart - Sales by Month

I am trying to create a Pie chart that shows sales for a single month rather than the whole year. Can you please help me in this?

3 Replies
Anonymous
Not applicable
Author

Here is what i recommend:

1. Create a selection field on year and month

2. Create your graphic object pie chart with Day as Dimension and sum(LineSalesAmount) for Expression

Selecting a given year and month on the sheet and you will have a nice pie chart with all sales day by day for the given year and month.

Hope this will help you.

sunny_talwar

May be use set analysis in your pie chart expression. Something along these lines:

Sum({<DateField = {"$(='>=' & Date(MonthStart(Max(DateField)), 'YourDateFieldFormatHere') & '<=' & Date(Max(DateField), 'YourDateFieldFormatHere'))"}>} Sales)

nagireddy_qv
Creator II
Creator II

Hi Vishal,

You can do this in 2 ways.

1. Create a Calculated dimension

2. Set analysis in pie chart expression ex:Sum({$<Month={'Jan'}>}  Sales)