QlikView App Dev

[#1]

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?

[mauricewehbe]

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]

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)