Year selection is not working

Anonymous — Wed, 11 Feb 2015 15:11:29 GMT

Hi,

Below is my Expression and i have a list box FinancialYear.

SUM({<[Moved From]=,[Moved To]=,%TFromToKey =, %MFromToKey=,PostingDate=,dtmAddedOn={'$(=vMaxWeekStartDate)'},

Opp_Status={'Closed'},CalendarMonthAndYear=,CalendarMonthName=,FinancialYear=,GoLiveFlag={1},[Probability %]=,Probability=,LastandCurrentMonth=

,[Billing Start Date]={">=$(=Date(YearStart(vMaxWeekStartDate,0,4)))<=$(=Date((vMaxWeekStartDate)))"}

>}Amount_in_USD) .

On selction of FinancialYear im getting value for FY15 and not getting value for FY14.

vMaxWeekStartDate =Date((MAX({1<CurrentDateFlag={1}>}PostingDate)))

Kindly please kind suggest me if any expression corrections required.

InAdvacne

Thank you

Re: Year selection is not working

giakoum — Wed, 11 Feb 2015 15:19:00 GMT

your problem is this one obviously :

[Billing Start Date]={">=$(=Date(YearStart(vMaxWeekStartDate,0,4)))<=$(=Date((vMaxWeekStartDate)))"}

vMaxWeekStartDate =Date((MAX({1<CurrentDateFlag={1}>}PostingDate))) means that you only get results for 2015. The 1 identifier makes sure that this is the case, regardless of selections.

try replacing 1 with $ but most likely the solution will be more complicated than that

topic Re: Year selection is not working in QlikView

Year selection is not working

Re: Year selection is not working