Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER 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
mauricewehbe
Creator
Creator

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)