Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
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

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.


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)

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)