Should display data of particular selecction

[#1]

Hi all,

My requirement is on clear selections i want to display present year data with all months(Fiscal Month-Apr-Mar).

But when i select 2015 and moth Mar its giving data 2016 & upto Apr to Mar, But i want only data of 2015 and March on that selection.

Thanks in advance.

[vikasmahajan]

Hi,

Kajal is master calender is created what set analysis you are using give some inputs or create dummy qvw and post

Vikas

[stephenedberkg]

post your expression here?

[#4]

on clear selection to display present year with all months data:

=if(GetFieldSelections([Fiscal Month])>=1,Sum( {<[Billing Date]={">=$(vCurrentMonthStart) <=$(vCurrentDate)"},[Fiscal Year]= ,[Fiscal Month]= ,[Fiscal Quarter]= >} [Billing Qty])
,Sum( {<[Billing Date]={">=$(vCYearStart) <=$(vCurrentDate)"},[Fiscal Year]= ,[Fiscal Month]= ,[Fiscal Quarter]= >} [Billing Qty]))

But if I select single year and single month it should display data for that selected year and month i want this both how to write this.

[ahmar811]

Please post your sample .qvw file to  clarify your problem

[Digvijay_Singh]

Try using this expression in straight table, it will show the result of your set expression in header if you don't change the label.