topic Re: Pie Chart - Sales by Month in QlikView

Pie Chart - Sales by Month

Fri, 12 Feb 2016 06:31:15 GMT

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?

Re: Pie Chart - Sales by Month

Anonymous — Fri, 12 Feb 2016 19:03:20 GMT

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.

Re: Pie Chart - Sales by Month

sunny_talwar — Fri, 12 Feb 2016 19:16:37 GMT

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)

Re: Pie Chart - Sales by Month

nagireddy_qv — Fri, 12 Feb 2016 19:18:35 GMT

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)