topic Month comparesion in QlikView

Month comparesion

Thu, 07 Jun 2012 06:16:52 GMT

i have 12 months data for sales, pages,visit,view .

i want to show comparesion between months

like when user select march , chart will show data for march as well as feb only two monts at a time.

i need help ,how to show this in chart.

masha-ecraft — Thu, 07 Jun 2012 06:31:51 GMT

Make a chart with two expressions: sum(Sales) for the selected month and sum({<Month=Month-1>} Sales) for the previous month.

Thu, 07 Jun 2012 07:01:11 GMT

i want to know how to calculate sales for selected month,if i give expression sum of sales

it will show sales for 12 months in chart.

masha-ecraft — Thu, 07 Jun 2012 07:03:33 GMT

If you have only one month selected then sum(Sales) shows sales for that selected month. If nothing is selected then Sum(Sales) is your total sales.

nilesh_gangurde — Thu, 07 Jun 2012 07:05:20 GMT

Hi shantanu,

If possible Please attach the sample data with qvw file.

Regards,

Nilesh Gangurde

Thu, 07 Jun 2012 18:56:25 GMT

sum({<Month=Month-1>} Sales)

this code not working gives same value as selected mont

could u please check it